Hi, All
I have been working on a client system for the past 3 weeks now and i'm neer completion except for one thing, the RECEIVABLES.
Does anyone have suggestions on how it should be constructed i.e. laydout.
MORE:
I have about 100 and will expect neer the thousands of clients once i'm done
and all of these clients need to pay for the service every month.
I have my database already made with test clients in it now i can enter them edit them and delete them, but i am now up to the receivables and have no clue on an efficient way of going in every month and posting who has paid? who has not and if paid how much of what ammount?
whats a good account methode?
Thanks in advanced.
Receivables Database Questions and Comments Needed
Moderator: General Moderators
-
litebearer
- Forum Contributor
- Posts: 194
- Joined: Sat Mar 27, 2004 5:54 am
It often helps to consider how you would handle it if you were in the 'pre-computer' days. Generally a T account where you would post debits and credits. So you would need as a minimum the following fields
client_id
Invoice_id
Date
debit_amount
credit_amount
since AR is an asset, the debits would be the money owed you and the credits would be the money received.
there is a myriad of info you could glean for those fields
client_id
Invoice_id
Date
debit_amount
credit_amount
since AR is an asset, the debits would be the money owed you and the credits would be the money received.
there is a myriad of info you could glean for those fields