Debtor, Monthly split

 

[Revised Mar 02].

 

Each statement shows the analysis of amounts still owing for previous months. There are some situations that can cause the monthly split to be incorrect, but nevertheless the total owing will always be correct.

 

Split, and GST displayed on statement, Incorrect due to journal entry being used for payment.

Journal entries are applied to the current month (different from the 'received on account'  key which applies payments to the oldest amount owing). This can result in a negative amount owing for the current month and positive for months before, though the total will be correct.

Therefore do not use 'journal entries for payments unless it is a dispensary-only system that does not have the POS module with a 'received on a/c' key.

Note; Use of the ''journal entry' key to enter payments will also affect the GST calculation which may therefore be wrong. Those who are doing a lot of account sales to other businesses where correcting the GST figure by hand will be irksome really need the POS module so they will have full debtor facilities.

 

Split incorrect due to credits

Likewise, credits from returned goods are applied to the current month, no matter when purchased. This can result in a negative amount owing for the current month and positive for months before though the total will be correct.

 

Split incorrect if date adjusted

If the date is 'fiddled' for some reason, such as to force an earlier or later End-of-month calculation, it is easy to roll the debtors over twice or not at all. The amount owing will not be affected but the splits will be wrong.

 

Split Incorrect due to debtors rollover being interrupted

If the debtors end-of-month rollover is interrupted or crashes then some debtors will not be rolled over. If it is then redone, some will be rolled over twice. Either way, some will have the wrong monthly split, though the total owing will always be right.

 

Related topics

GST override at time of sale

Journal entry

Received on account