We give clients an option to pay in installments over several months. We record in quick books as an invoice and receive payments against that invoice and we only issue them the product (and therefore incur costs of sale) when the invoice is fully paid. This has caused issues with year-end report in quickbooks, which counts the full value of the invoice as income (for example, say an invoice of 5000 is raised in year 1 but due in year 2. Even if the customer only paid 500 in year 1, quickbooks shows the full 5000 as income of year 1 when I run a profit and loss report. How can I fix that?
Let's elaborate on some details when recording invoices and payments in QuickBooks, Mab31.
Sometimes, you may find it confusing why a different amount of income is reflected and doesn't match the payments you've entered. The main reason why this is happening is because of the accounting method that you're using.
With the accrual method, your business reports income and expenses for completed and pending transactions that show up on your financial report. And that is happening in your case where it shows the full amount of 5000 as income when your customer only paid 500. But, if you use the cash method, your business reports the income and expenses for completed transactions.
Aside from that, when running the Profit and Loss report, for invoices and received payments, the revenue information is contained in the invoice. While the expense is tracked by the bill and bill payments. At the same time, the cash basis reports will also use the invoice or bill date.
You'll want to choose the correct accounting method when running the P&L report. To do that, follow the steps outlined below:
Furthermore, you can use this guide to complete year-end tasks and end of-year smoothly, I've added this article for more details: QuickBooks Online Year-End Guide Checklist.
Reply to a comment below if you have any questions when running financial reports. I'll be one post away if you need further assistance. Have a nice day!
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.