cancel
Showing results for 
Search instead for 
Did you mean: 
Bteam1
Level 1

How to reconcile payments with no invoice in QBO?

I recently upgraded from desktop to QBO, but since our file was so large, we decided not to import the full company file.  As a result, I'm still collecting payments from 2023 invoices that don't exist in QBO.  When i get a client payment that has 2023 and 2024 payments, I can only reconcile the 2024 payments and then have left over money.  How to you categorize that extra payment amount?

Thanks, Chris

4 Comments 4
FishingForAnswers
Level 9

How to reconcile payments with no invoice in QBO?

@Bteam1  If you need to apply a payment to an invoice, the invoice must exist in your system.

 

If the invoice does not exist in your system, you should recreate it.

 

There are probably some workarounds you could do instead, but I'm not sure why you wouldn't just do it the normal way.

 

Also, you have my sympathies for your downgrade from Desktop to QBO.

Bteam1
Level 1

How to reconcile payments with no invoice in QBO?

Thanks, there are a lot of invoices, so i was trying not to re-create each one manually, just to match the payment with invoice.  I thought i could categorize the payments as something other than income, so that it doesn't show up as newly generated revenue for when the deposit was made.  I wasn't sure if the unapplied income or uncategorized income categories would work for these instances? Or if there is another category that i could use?

FishingForAnswers
Level 9

How to reconcile payments with no invoice in QBO?

@Bteam1  Well, I guess the most important question would be whether you are on cash or accrual basis.

 

The problem being that, if you are accrual, the invoice date would matter a great deal in determining which year has the relevant income.

 

At any rate, tossing this one over to @Rainflurry ; I'm not familiar enough with QBO to suggest a good non-traditional route.

Rainflurry
Level 14

How to reconcile payments with no invoice in QBO?

@Bteam1 

 

"I thought i could categorize the payments as something other than income, so that it doesn't show up as newly generated revenue for when the deposit was made. I wasn't sure if the unapplied income or uncategorized income categories would work for these instances? Or if there is another category that i could use?"

 

A couple of thoughts:

 

1) If you don't want to record it as revenue, then you must be on accrual basis, correct?  If you're on accrual basis and your 2023 open invoices are not in QBO, then your A/R balance presumably is understated by that amount.  What other account is off by that amount?  Retained earnings (RE)?  If so, you can assign RE to the payments received to increase RE. 

 

2) Consider exporting your open invoices from QB Desktop into an Excel file and then import just your 2023 open invoices into QBO.  That's pretty quick and easy.    

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us