Share
Report
1,290
Dear All,
We have a petty cash bank account, each month end we request from the management to transfer from a bank current account to the petty cash account our monthly expenses, the accountants spend great effort preparing an excel sheet clarifying the amounts paid and the reason of the payment, all information are in the GP but we do not know how to get it.
Please note the following, and help me to get the information in a proper report, let me assume that the expenses of this month are USD 500 paid in one check from petty cash bank account, the Journal Entry the accountants currently do (they do not use bank reconciliation):
Petty Cash Bank Account Credit
500 Reference: Office Expenses
Electricity Debit
250 Distribution Ref:
Electricity Invoice No1
Water Debit
250 Distribution Ref: Water
invoice No 2
If I print the detail of the account, it will show:
Reference: Office Expenses Credit
500
But my need is to show the following:
Distribution Ref: Electricity Invoice No1 Debit
250
Distribution Ref: Electricity Invoice No2 Debit
250
So the accountants prepare the list on excel, imagine how much effort does it take if we have 250 transactions each month, they do it all again on excel.
How can I get the information that I need in one click?
Best Regards,
*This post is locked for comments
All responses (
Answers (
