Bank accounts - Export list of unreconciled items from Account Transactions screen
Be able to export to Excel the Account Transactions screen from the bank that shows the unreconciled items
Rachael Egan
shared this idea
Hi all, I wanted to share that while there's no export option on the Account Transactions screen itself, it is possible to export a list of unreconciled Account Transactions with the Business Bank Account Reconciliation Summary report. If you export a copy of this to Excel you'll find the sections for Plus Outstanding Payments and Less Outstanding Receipts which are the unreconciled account transactions. Hope that helps 😊
-
Melanie Currie
commented
When clients have not provided the required receipts to complete bookkeeping, I always have to generate a list of expenses they need to support.
Rather than going to the "Bank Statements" highlighting, copying, pasting unicode text to excel and filtering out "reconciled" items, I would like to just click an "export list" button from the "Reconcile" screen and have it generate the list of transactions remaining. -
Andrew Syme
commented
Hi Hannah, How can I run the Business Bank Account Reconciliation Summary report for ALL the Bank Accounts in one Report ?
-
Anette Abrahamsen
commented
Nice idea, Kelly, the problem is that we don't have the button Uncoded Statement Lines.