Bank Rec

(5) Share

Report

Posted on by BG-02091842-0

Our bank sweeps our account daily so how to you do bank rec when opening and ending statements are 0.00?

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (1)

Sort by

Verified answer

Teagen Boll 3,868 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

You would just have to make sure that your bank statement ending balance and balance last statement are 0$. You in theory could still complete a bank reconciliation monthly with all the activity but it is up to you. See an example below, all those highlighted fields would be 0$:

Best,
Teagen Boll, CPA
LinkedIn
Blog posts
Suggested answer

OussamaSabbouh 19,350 Super User 2026 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Hello,
Yes, you can reconcile the account normally even when both the opening and ending bank balances are 0.00. On the Bank Account Reconciliation, enter the statement date and Statement Ending Balance = 0.00, import or enter all transactions for the period, and match them against the Business Central Bank Account Ledger Entries. The important point is that the daily sweep itself must also exist in Business Central—normally as a transfer from this bank account to the concentration/sweep bank account—so, for example, deposits of 10,000 followed by a 10,000 sweep will net back to zero but both transactions are still reconciled. Business Central doesn't require a nonzero ending balance; it requires the statement transactions and BC bank ledger entries to reconcile to the stated ending balance. If the previous reconciliation also ended at zero, Balance Last Statement should automatically be zero as well. If the sweep transaction isn't recorded in BC, that is what will remain unmatched/different.
Regards,
Oussama Sabbouh
Suggested answer

CU03020606-0 88 on at

Like (0)

Report
Copy link

Link copied!

Yes, you can reconcile the account normally even if both the opening and ending balances are 0.00.
Enter the statement ending balance as 0.00 and reconcile the transactions for the period against the Bank Account Ledger Entries in Business Central.
With a daily sweep, the important thing is that the sweep transactions are also recorded in BC. For example, a 10,000 deposit followed by a 10,000 sweep will leave the account at 0.00, but both transactions still need to be reconciled.
So the key is to reconcile the transactions, not the balance. If the sweep entries aren't in BC, those will likely be the items causing the difference.

Thanks, Sanket
Suggested answer

AndrewThomas81 2,717 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

You can reconcile a 0 balance, just enter 0.00 in the statement end balance.

You would need to post bank account ledger entries to transfer the sweep to your other account

Kind Regards

Andrew Thomas FCCA MCP
YouTube - Use Business Central
LinkedIn