Did you know that you can download a bank transaction reconcillation report in Microsoft Excel format? This is useful for clients with very large weekly settlements containing a lot of individual line items. Please follow these steps the day after payment has been made to your account:

  1. Log into BookIt at http://business.bookit.co.nz
  2. Click the "Reports" tab
  3. Click "View" next to "Completed Payments"
  4. Enter the date range you would like to query. If you are just trying to reconcile a single bank transaction, set the start and end dates to the date the payment was made to your bank account
  5. Click "Update"
  6. After a few moments the report will appear
  7. Choose Excel from the dropdown menu and click "Export":



  8. You will be asked to save or open the file. Click "Open" to view the file in Excel. 

Please contact us should you require assistance, or leave us a comment.