Skip to main content
July 9, 2020
Question

how to Show invoices spread over the year.

  • July 9, 2020
  • 1 reply
  • 0 views

hi everyone.  I have a SAGE invoice(!) which in January they send it to me in full and then I pay this back each month by the same amount by Direct Debit.  How would you put this onto Quickbooks? I put the whole invoice in January but of course only paid a portion in January.  My reconciliation is now out as I still have 11 months outstanding in January. Thanks in advance. 

1 reply

July 9, 2020

Hello, farmgirlkent69.

 

I'll be glad to show you how you can handle the supplier bill or invoice in QuickBooks Online. I'll also include a bunch of images to better guide you (click to enlarge them). 

 

You did the right thing by adding the whole invoice in January (since this is exactly what happened in reality). To handle the payments, you can leave the invoice (bill) as open then record the payments (in portion) month by month until paid in full. 

 

 

I take it that you've already connected your bank account. In this case, you'll just want to match the payments made for the month against the open bill or invoice.

 

Since you've already recorded the partial payment for January, you'll simply want to match it with the transaction in QuickBooks. Here's how: 

 

  1. Go to the Banking menu, then choose your bank account.
  2. Under the For Review tab, look for the portioned payment. 
  3. QuickBooks will automatically recognise the matching payment. Simply click the Match button.

 

 

You don't have to record the rest of the payments in QuickBooks. Simply match the bank transactions (the portioned payments) against the outstanding supplier bill or invoice.

 

  1. In the For Review tab again, find the payment for the month.
  2. Select it then click the Find match radio button. 
  3. Check the outstanding bill, then click Save

 

 

Since we only recorded a single invoice or bill, it won't spread over the year. Instead, the payments will be shown month by month. You can pull up the Bills and Applied Payments report.

 

Simply go to the Reports menu, then choose Bills and Applied Payments under the What you owe section. Here's a sample view: 

 

 

To ensure your reconciliation is correct, you'll want to follow your bank's statement end date and balance. Reconcile your bank account in QuickBooks in between each statement.

 

The open bill won't affect your reconciliation statement. You only need to look for the payments made and ensure they match the cash flow in your actual bank account. 

 

 

Continue making bill payments until you fully paid the invoice. I'd also recommend reaching out to an accountant to double-check your books and reconciliation process. 

 

If you need help reconciling your accounts, I'd recommend reading these articles: 

I'd also suggest browsing our articles if you need help with other things in QuickBooks. Choose a topic and select an article here

 

Don't hesitate to visit the Community forums again if you have follow-up concerns. Our team would be more than happy to show you how to get things done in QuickBooks Online.