Skip to main content Skip to main navigation
Skip to access and inclusion page Skip to search input

How to create a Reconciled Invoices Reports in Biz Invoice

Login to Biz Invoice from your mobile or desktop.

How do I calculate total sales?

1. Download the reconciled payments summary by clicking on ‘Reports’ and then ‘Download CSV’

2. Sum the amounts in column K (11th column) titled ‘Total Reconciled Payments’. More help on summing cells in Excel

How much GST have I collected?

Only available for Biz Invoice profiles linked to a Business One Low or High Plan account.

1. Download the reconciled payments summary by clicking on ‘Reports’ and then ‘Download CSV’

2. Sum the amounts in column J (10th column) titled ‘GST on Reconciled Amount’. More help on summing cells in Excel

What is the total $ of Biz Invoices sent?

1. Download the reconciled payments summary by clicking on ‘Reports’ and then ‘Download CSV’

2. Sum the amounts in column E (5th column) titled ‘Invoice Total’. More help on summing cells in Excel

Note: This is the total value of Biz Invoices sent which is different to total income received from Biz Invoice (column K).

Limitations of the Reconciled Invoices Report

The ‘Reconciliation Date’ in the reconciled payment summary (column H) reflects the date on which a payment was reconciled in Biz Invoice (either automatically or manually). This may not be the date on which a payment was received into your bank account.


Read more

How to set up Biz Invoice in 3 steps

Once you have registered for Online Banking and have access to an eligible account*, set up Biz Invoice in three easy steps – desktop and mobile.

Help reconcile and control your cash flow

Get more help on setting up Bank Feeds, including help videos.

Business hints & tips

Whether it's getting set up for success or saving time. Get up to date hints and tips for running your business.