I've been asked to maintain a small program that tracks fees charged for attending a conference versus payments for those fees. A table called Ledger has an entry for each fee and an entry for each payment. The "fee" goes in the table as a positive number; the payment goes in the same field but as a negative number. A simple sum of that field accurately provides the registrant's account balance. Likewise, a sum of the "Payments" (which are negative numbers) gives an accurate representation of the amount paid, while a sum of the "fees" (which are positive numbers) accurately shows the amount due/assessed.
The problem arises when someone overpays. The software has a facility for entering "credits," but they go into this ledger table as negative numbers, which distorts the registrant's account.
For example, a registrant is assessed fees of $49, $89 and $75 (=$213), and has a payment of $275. If the software puts in a CREDIT of $62, it goes into the ledger as a negative number, so that a sum of the fees is $213, but a sum of the payments/credits is $337. If the "credit" had gone in as a positive number, it would have correctly shown payments of $275 and an offsetting amount ($62)--essentially a refund given the registrant--to bring his balance to zero.
I apologize for what is a very long and probably barely understandable explanation, but my question is, Why does a "credit" go into the ledger as a negative number if it is intended to offset an overpayment? Should it also go in the ledger as a negative number if it is intended to reduce the amount charged for something? Are there different kinds of credits? (Sorry. Not an accountant and don't really understand even this simple system of recording fees and payments.)
The problem arises when someone overpays. The software has a facility for entering "credits," but they go into this ledger table as negative numbers, which distorts the registrant's account.
For example, a registrant is assessed fees of $49, $89 and $75 (=$213), and has a payment of $275. If the software puts in a CREDIT of $62, it goes into the ledger as a negative number, so that a sum of the fees is $213, but a sum of the payments/credits is $337. If the "credit" had gone in as a positive number, it would have correctly shown payments of $275 and an offsetting amount ($62)--essentially a refund given the registrant--to bring his balance to zero.
I apologize for what is a very long and probably barely understandable explanation, but my question is, Why does a "credit" go into the ledger as a negative number if it is intended to offset an overpayment? Should it also go in the ledger as a negative number if it is intended to reduce the amount charged for something? Are there different kinds of credits? (Sorry. Not an accountant and don't really understand even this simple system of recording fees and payments.)
Single-entry accounting software records credits as negative. Is that always correct?
0 commentaires:
Enregistrer un commentaire