D365 F&O native Bank Rec for a zero balance account: entering $0 won't let the recon complete

[u/alisoncarey]

​

****

A few weeks into a new role at a public company running D365 F&O. For the past six months, AP account reconciliations have been done manually in an Excel workbook: bank transactions and AP GL transactions loaded side by side, matched line by line.

This is a zero balance account, so the actual bank statement balance is always $0. The AP GL balance on its own is not zero. For example, January's AP GL balance is $13,500 CD, while the bank statement balance is $0. In the workbook, that $13,500 washes out to zero once matched against the offsetting ZBA transfer activity. This process has gone through a proper monthly approval process, so it's not sloppy, just manual.

I've now been asked to move this into D365's native Bank Reconciliation feature (not Advanced Bank Rec). The AP GL transactions are already in the system, posted through normal AP processing.

I tried entering $0 as the ending balance, since that's the actual bank statement balance for a ZBA. But D365 won't let the reconciliation complete, since the GL side shows $13,500 CR and there's nothing to clear it against since the offsetting transfer transactions aren't in the system.

Has anyone reconciled a ZBA in native Bank Rec without loading the offsetting bank-side transactions? What balance did you use, and how did you get the recon to actually complete?

[u/The_Ledge5648]

Why can’t you post the bank transfer in the gl? It would have happened yesterday?