How to import accounts receivable balances without adding taxes that have already been accounted for.

s_reynolds · ‎February 03, 2023

I am trying to figure out how to bring in our outstanding Accounts Receivables from another accounting package.

I have 2 issues here.

1. Some are partially paid invoices and we only want to bring over the balance owing.

2. We do not want to end up with reporting the tax a second time as that was recorded in previous periods.

What we want to do in the upload is something like this:

Invoice #	Customer	InvoiceDate	DueDate	ItemAmount	ItemTaxCode
1001	Jane Doe	12/15/2022	12/15/2022	1050	GST

In this case the item amount would be the total opening balance for this invoice. Some of these invoices are partially paid.

We do not want to enter individual product lines for these imported invoices.

Trish_T · ‎February 06, 2023

Hi s_reynolds,

QuickBooks Online enables you to import your data with ease. I'd be glad to help!

When preparing your file to import it to QuickBooks Online, it's important to review the 'sample' template to ensure accuracy. You can edit your spreadsheet according to your business needs, but the overall layout must be exactly as shown in the 'sample' file. However, if there are any columns you don't want to include in the import, you'll simply leave them blank. It's not recommended to remove the columns from the spreadsheet as it will cause an error during the import process. Also keep in mind that there should be no empty lines between items on the spreadsheet. Spacing is also important and empty lines should be removed for a smooth transition to your QuickBooks Online account.

For additional assistance, please don't hesitate to contact us outside of Community. We'd love the opportunity to work with you in real time and help you accomplish your QuickBooks goals as soon as possible!

Schedule a Callback or start a Chat: click (?) Help in the upper right in QuickBooks Online > enter "Contact support" > hit Contact Us > provide a brief summary of your situation > hit Let's Talk > choose Get a callback or Start a Chat.
Social Media: Facebook, Twitter, and Instagram.
Support hours are from Monday to Friday between 9 a.m. and 8 p.m. ET.

We'd be happy to answer any other questions you may have. We're always happy to assist!

s_reynolds · ‎February 13, 2023

I discovered the solution to this later. I just had to mark the Tax field as "Out of Scope".

Topics

Training

Community

Resources

How to import accounts receivable balances without adding taxes that have already been accounted for.

How to import accounts receivable balances without adding taxes that have already been accounted for.

How to import accounts receivable balances without adding taxes that have already been accounted for.

Need to get in touch?