Skip to main content

Next Generation - Due date and receipt date calculation for the sales ledger

This article aims to provide comprehensive understanding of the functionality of the due date and anticipated payment date for sales invoices and credit notes.

When entering or amending a sales ledger invoice, credit note, you may amend the transaction due date and anticipated receipt date.

The Due Date, found on the transaction header and the Receipt Date, found under the Date tab, can't be left blank. You can overwrite both dates.

The Due Date is calculated based on the customer terms Due Days and Due Days Method.

The Anticipated Payment Days are calculated from the Anticipated Days field in the customer terms. This can be set to be calculated based on the invoice date or the due date. The anticipated payment days = invoice date or due date + anticipated days.

Due Days Method

Calculation

Example

x Days from Invoice

Invoice date + customer terms Due Days.

  • Customer Terms = 14 days from invoice

  • Invoice date = 1 February

  • Due Date = 15 February

End of Following Month

Last day of the month following the invoice month.

  • Invoice date = 5 March

  • Due Date = 30 April

x Day of Following Month

Specified day of the month following the invoice month.

  • Customer Terms = 10 Day of Following Month

  • Invoice date = 5 March

  • Due date = 10 April

x Days After End of Month

Specified number of days after the end of the month that the invoice date falls into.

  • Customer Terms = 40 days after end of month

  • Invoice date = 21 February

  • Due Date = 9 April


Due Date is manually amended then Due Days are recalculated as follows:

Due Days Method

Calculation

Example

x Days from Invoice

Invoice date - customer terms Due Days.

  • Customer Terms = 14 days from invoice

  • Invoice date = 1 April

  • Due Date amended to 20 April

  • Due Days = 19

End of Following Month

N/A

  • Due Days = zero

x Day of Following Month

Due Days is set to the day entered by the user.

  • Customer Terms = 10 Day of Following Month

  • Invoice date = 3 February

  • Due Date amended to 15 March

  • Due Days = 15

x Days After End of Month

Due Days is recalculated as the number of days between the end of the month that the invoice date falls into and the specified date.

  • Customer Terms = 40 days after end of month

  • Invoice date = 21 February

  • Due Date amended to 15 April

  • Due Days = 46

Note: The Due Date can't be set to be an earlier date than the transaction date.


The Anticipated Receipt Date is calculated from the Anticipated Days field in the customer terms. Anticipated Receipt Date = Invoice date + Anticipated Days.

Anticipated Receipt Date is manually amended, then calculations are as follows:

Anticipated Receipt Date

Calculation

Example

Receipt Date

Anticipated Receipt Date less invoice date

  • Invoice date = 1 March

  • Anticipated Receipt Date is manually set to 15 March

  • Anticipated Days = 14

Note: The Anticipated Receipt Date can't be set to an earlier date than the transaction date.

Did this answer your question?