Hi Guys
I have a concern here with the Bank Reconciliation, Need your help to solve this issue.
We are receiving daily collection from the Salesman which are against different invoices, these are entered in the system as individual receipt entry and finally at the day end deposited in the Bank as a single deposit entry. To reconcile it is very difficult as the bank statement shows a one line entry whereas I have a huge number of line entries. Please suggest how to do the reconciliation.
Hope that you have understood the issue.
Receipts :
1. Customer1 25.000
2. Customer2 15.000
3. Customer3 10.000
4. Like this ‘n’ number of customers and the total might come to a single figure. Say for argument sake USD. 25000/-.
Now this 25000 is deposited in the bank as one entry, so the bank statement will show 25000 deposited but it will not show all the receipt numbers. Now when I am reconciling Accpac will give me a detailed report with all the receipt numbers and the bank statement has only one entry, How do I correlate and do the reconciliation.
I have a concern here with the Bank Reconciliation, Need your help to solve this issue.
We are receiving daily collection from the Salesman which are against different invoices, these are entered in the system as individual receipt entry and finally at the day end deposited in the Bank as a single deposit entry. To reconcile it is very difficult as the bank statement shows a one line entry whereas I have a huge number of line entries. Please suggest how to do the reconciliation.
Hope that you have understood the issue.
Receipts :
1. Customer1 25.000
2. Customer2 15.000
3. Customer3 10.000
4. Like this ‘n’ number of customers and the total might come to a single figure. Say for argument sake USD. 25000/-.
Now this 25000 is deposited in the bank as one entry, so the bank statement will show 25000 deposited but it will not show all the receipt numbers. Now when I am reconciling Accpac will give me a detailed report with all the receipt numbers and the bank statement has only one entry, How do I correlate and do the reconciliation.