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. -
Lynn Sheppard
commented
When searching for specific bank transactions(s) using the filter option, when found, it would be good to be able to export your findings directly from your screen. This would prove to be a very efficient way of exporting specific data quickly.
-
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.