Import payroll transactions into Quickbooks from Accounting CS

pinnacletax · ‎September 23, 2020

I am trying to import payroll data/transactions from Accounting CS into Quickbooks so I don't need to re-enter 9 months of data. I was able to export the transactions out of Accounting CS and generated a file with an extension qbw.qbexportdata and now I'm trying to figure out how to import that data in to Quickbooks.

The Quickbooks file I have is a brand new file I just created so there isn't any data to worry about overwriting. I tried the Utilities > Import > and it isn't an IIF or Web Connect file.

I tried changing the extension to be just .qbw and tried to open it that way but can't.

I tried calling QB support and got no help there either.

Fiat Lux - ASIA · ‎September 23, 2020

Export your data out to XLS/CSV and prepare them with the following template

RefNumber

Transaction Date

Account

Debit

Credit

Memo

Name

Class

Billable

Is Adjustment

Currency

Exchange Rate

Home Currency Adjustment

Amounts in Home Currency

1

27/09/2020

Checking

130

PR 092518

John Smith

N

1

27/09/2020

Wages

200

PR 092518

John Smith

N

1

27/09/2020

Payroll Taxes Payable

50

PR 092518

John Smith

N

1

27/09/2020

Health Insurance Payable

20

PR 092518

John Smith

N

Then utilize the trial period of these importer tool to import data as Journal Entries

https:// transactionpro.grsm.io/qbd

https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

BigRedConsulting · ‎September 23, 2020

Unfortunately it is not possible using any method to import Paychecks into a QuickBooks company file.

Topics

Training

Community

Resources

Import payroll transactions into Quickbooks from Accounting CS

Import payroll transactions into Quickbooks from Accounting CS

Import payroll transactions into Quickbooks from Accounting CS

Need to get in touch?