cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
P4NCH
Level 1

How to bulk assign a payment (with date) to an invoice via spreadsheet?

Hi,

 

I've imported a bunch of invoices and had to manually pay each one again (reconcile) after the import.

 

I need to import another two batches, is there away to assign the payment via spreadsheet (i.e separate column with date of payment) before importing invoices?

 

Regards, P4NCH.

1 REPLY 1
MaryLurleenM
Moderator

How to bulk assign a payment (with date) to an invoice via spreadsheet?

We're unable to automatically link imported invoices with payments, P4NCH.

 

You'll need to receive the payment for each invoice. Or you can download your bank transactions as a CSV file and upload it in QBO. Once done, you can reconcile your bank account to make sure that you're not missing any transaction in the bank register.

 

The steps on how to enter historical transactions are in this article: How to enter historical information.

 

Let me know if you have more questions.

Need to get in touch?

Contact us