Hi Louise,

Within the Credit Control tab of each Customer record you can set the following:

• Customer Credit Limit
• Settlement Due and relevant settlement discount
• How many days the customerâ€s payments are due by

As well as these features, Sage Accounts also has other Credit Control features such as the Chase Debt option, the ability to record Communications, view transaction histories and aged balances for your accounts.

For full information on how to do this please refer to Ask Sage article 31664:

support.sage.co.uk/default.aspx

Hi Paul

Thanks for replying. All of the above has been done but I can't find anywhere to specify or calculate a due date for the end of month or a specific day of the month. Do you know if it's possible to do this please?

Hi Louise,

The Invoice due date in Sage Accounts is calculated in the following way:

Invoice date + number of days entered in the Payment Due Days box in the Credit Control tab of the Customer Record.

This date is recorded when the transaction is posted and does not change retrospectively if other dates are amended.

You can run the following reports in Customers > Reports to report on any due and overdue payments:

•Customer Invoices Due - CSTIVDUE.report
•Customer Invoices Overdue - CSTIODUE.report

Hi Paul

Thanks again, I think what I'm after then seems not possible? Any report I run will give me inaccurate information because it will be calculating the due dates incorrectly, showing invoices as overdue when they're not. Eg., If a 30day EOM customer has 2 deliveries in a month with invoice dates of let say 5/3/15 and 16/3/15, both invoices would be due 30/4/15 but Sage will not/can not give me this date? Sorry to be a pain, or if I am being thick but am I missing something or is Sage just to basic for my needs?

*too basic

Hi Louise,

Yes, the way you calculate your due dates appears to be different to the way Sage Accounts calculates them. Therefore, you wonâ€t be able to use this function in Sage Accounts.

However, what might help you with the way you calculate your due dates is the Customer Ageing settings. These are in Settings > Customer Defaults and can be set to either Calendar Monthly or Period Ageing.

Calendar Monthly Ageing ages transactions by calendar month rather than by the number of days the transaction is outstanding. This means that all of a month's transactions will be classed as outstanding on the first day of the following month.

Period Ageing ages transactions by a certain number of days. The defaults are 30, 60, 90 and 120 days but if required you can enter your own number of days.

You can run the Aged debtors reports to report on the ageing of your transactions.

For full information on ageing periods in Sage Accounts you can refer to Ask Sage article 31664:

support.sage.co.uk/default.aspx