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

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 😊
-
Steph Burnett commented
THIS!! Every other page seems to have the facility to 'export' the data on it at the bottom either by way of PDF or Excel - but the outstanding reconciliations page doesn't have this? What I want to be able to do it click on the blue 'reconcile X items' button, then on THAT page have a simple way of printing the outstanding items so I can then go off and collate the paperwork for any missing items! As a small business owner I only 'account' once a month and the paperwork to support line entries might be on an email, on someone's desk or in someone's wallet so I then run round with a ****** screenprint trying to track down the paperwork it just seems odd that you can literally print off everything possible EXCEPT this
-
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.