Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
mbestgen
Level 1

Batch Enter Transactions - Amounts for Account Items are 0

When batch entering transactions from my excel sheet, every time I paste, the amounts for any line that has an account associated with it are turned to 0.00. This does not happen for any amount that has an ITEM associated with it, those are pasted over correctly. 

 

I've checked formatting, changed to number, checked for extra spaces, etc. I'm still getting zeroes and having to manually type the amounts all over again. 

 

Any help would be appreciated. 

1 Comment 1
MichaelaS
QuickBooks Team

Batch Enter Transactions - Amounts for Account Items are 0

I appreciate the steps you've taken, @mbestgen. I know that copying and pasting entries is indeed much more convenient. Let me clarify how this behavior is designed to enter batch entries in QuickBooks Desktop (QBDT).

 

Batch Invoices & Credit memo entries should include an associated item to ensure that the amount can be mapped to the appropriate account in Accounts Receivable (AR). Each item has a corresponding income account, which facilitates this mapping and allows it to be recorded in the AR register.

 

Therefore, you need to include items in Excel so that the registered amounts can be recognized by QuickBooks, helping you avoid manual entry.

 

Please see the screenshots below:

 

download.png

 

For visual guide, check this article: Enter transactions by batch in QuickBooks Desktop.

 

Additionally, you can refer to this article as a future reference for recording payments: Receive invoice payment.

 

If you have any other questions about entering batch transactions, I'm here to help and ensure your experience is as smooth as possible.

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up