I am familiar with Excel. I need some help with the manner in which I should organize my spreadsheet.
Currently, I am doing manual accounting. I maintain two books -- Bill (Sales) Book and Account Book.
A sample bill from the Bill book looks like this:
Date: 24/11/09
Party Name: ABC
Bill No: 123
Items Qty Rate Amt
.......................................
.........................................
.......................................
Total Amt .........
Add:Previous dues* .....
Total dues .........
*Previous dues must be the total of all dues receivable from the party.
A sample page from the account book looks like this:
Party Name:
Bill Date Bill No. Bill Amt Amt Recd Total dues
(The total dues column above is the total of all dues till date which is equal to "Total dues" in sample of Bill Book shown above)
Notes:
1. None of the payments are received bill-wise. So there is no need to cancel out a bill after payment is received.
example, if bill 1 is of amount 13,400 and bill 2 is of amount 12,400, the party will never bother to look at either 13,400 or 12,400. The party will only look at the "Total dues" and pay some amount.
How do I put the above manual system in Excel ?
Bookmarks