updating records

[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.

 

[alansidman]

Re: updating recods

Sounds to me that you need one more sheet to keep track of balances owed you. In Accounting jargon, this is called Accounts Receivable. It should not be confused with sales. Sales is an income statement account and Accounts Recievable is a Balance Sheet account.

Alan

 

[Rhinox]

Re: updating recods

yeah you're right, i havent thought of that. I am not good at accounting. So how do you think would i code that. Hope you could help. TIA.

 

[Rhinox]

Re: updating recods

"Total sales for the day is 1500"

sorry, just some corrections on my post. I mean total sales is 2500. Some typographical error-fingers.