updating recods

[Rhinox]

Hello everyone, i have a list of regular customers and were able to write a code which put all the transaction in a table. When a customer pay in cash, i put it in cash sales worksheet, but when they do not pay in cash i put it in the credit worksheet. Total sales for the day of course is cash sales and credit sales. My problem is how to update my customer records when their credit is already paid.

for example:

ON THIS DAY
on cash sales worksheet:
customer1 =500
customer2=500

on credit worksheet:
customer3=500
customer4=1000

Total sales for the day is 1500

ON THE NEXT DAY
Customer3 pays his credit of 500.

i put it in the payment worksheet.

Question is: how to update the status of customer3 from credit status to paid, balance upadated to 0.00

i hope you guys understand what i mean. Thanks in advance.

 

[tweedle]

From an accounting perspective, you should maintain a 3rd ledger (sub ledger) for Credit Receivables.

So a cash sale is Sales +500, Payment -500.
.
A Credit Sale is Sales +500, Credit Voucher -500
And the sub ledger Credit Receivables gets +500
and when that payment comes in it receives a -500

So the 6 credit transactions together net the customer balance to $0