Skip to main content

Producing a report that shows the difference for postings in a bank reconciliation

How can I show the difference from when I originally reconciled on the bank rec to now with the TB balance?

V
Written by Valeriu Holtea
Updated over 6 months ago

A report for the Cashbook can be run via the Report Generator:

  1. From the LAD desktop go to the Reports tab.

  2. Select Report Generator and then find the folder CASH BOOK.

  3. If there isn't a report already in that folder then a new one will need to be created, there is a separate Knowledge Article to do this.

  4. If there is one called ALL TRANSACTIONS ON A BANK/CASH BOOK these are the ones that you can use.

  5. Check what fields are showing in these and make sure you have the relevant fields to show the Date Posted/Date Reconciled.

  6. Add these by select the Fields tab and find the ones that you need and move over using the arrows.

  7. Once this is done select 'Apply Field Changes'.

  8. This will add the fields onto the report.

  9. Select the Info tab and then select Run Report.

Did this answer your question?