When updating a payment batch from Tax, create in Finance a separate debit lines for Cash and Cheks in the bank ledger
Currently all batches updated from Payment Window (Tax, Utility) interface with Finance by generating 2 lines on the bank ledger, one for Cash & Checks, the other one for Credits. This made sense when we used to deposit checks and cash with a deposit slip and they would go together to the bank. However, we are now sending checks remotely to the bank, and cash is still being sent with deposit slip. Therefore, the bank statement shows a transaction for checks (remote deposit), another one for cash (deposit), but the general ledger still shows one line for both. This makes difficult the reconciliation when both sources as both sources are not in line.
I would suggest to add a feature to the system that will allow users to decide on settings if we want the lines of cash and checks to be grouped or not.
On file attached the is a sample of the current general ledger for the bank. The reference # 28423 appears currently in one line. We need it to appear in 2 lines: $8,577.48 for Cash and $98,407.93 for checks, as it will appear on the bank statement.