You’re offline. This is a read only version of the page.
Announcements
171
Hi, I think you can use the following standard feature.
In W1:
To fill bank reconciliation lines by importing a bank statement
In Netherlands Local Functionality
Import and Reconcile Bank Statements
Hope this will help.
Thanks.
ZHU
Rob - great point. The more often you can do your bank rec, the lighter the load. I have had clients asked about auditors not getting a single bank rec. Auditors have unanimously stated that a closer watch of the bank account (reconciling daily or weekly) is always better than once a month.
We have the same situation with our main bank account. We are using the Yodlee Bank Feed service, and our accounting staff create the bank recs at the beginning of the month and then each day they open them and import the bank statement transactions from the previous day and match what they can. They use both automatic and manual matching (because some of our matches are many-to-one). By the end of the month most entries have been matched, and then they use the function to send unmatched entries to a General Journal batch for items such as bank fees and interest income. They enter the final ending balance in the bank rec header, make sure everything is balanced, and post the rec.
If possible, use the automated bank rec which allows for the importing of the bank statement. Then you can use the Auto Match, leaving only the unmatched for you to have to manually reconcile.
#1
André Arnaud de Cal...
294,137
Super User 2025 Season 1
#2
Martin Dráb
232,877
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
