Using the reconciled payments summary report

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 (11^th column) titled ‘Total Reconciled Payments’. More help on summing cells in Excel

How much GST have I collected?

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

2. Sum the amounts in column J (10^th 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 (5^th 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 payment summary 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.