Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
@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.
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?
@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.
"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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here