Blogs & News
How to add payment terms to your invoices in Sage 50 accounts
25 September 2023
Summary
To help customers pay you on time, you should make it clear how they can pay you and when payment is due.
An effective way to do this is to add your payment terms and bank details to the invoices you issue to them from Sage 50 Accounts.
NOTE: As not all sections of an invoice layout are visible when you print, you should ensure you add your terms to a printable section, for example, the invoice footer alongside your invoice totals.
How to add the trading terms text from the customer records
If your terms vary and you record them in each customer record in the Trading Terms text box via the Credit Control tab, you can add an expression to show the relevant terms for each customer:
1. Select the document you want to amend, then click Edit.
2. Click the Toolbox menu, then click Add Expression.
3. Click the area on the layout where you want the payment due date to appear.
4. In the Expression Editor window, enter the following expression:
“Payment terms: ” + SALES_LEDGER.TERMS
5. Lastly, click OK.
How to add a payment due date
If you use the Payment Due and Payment Due From fields in your customer records, you can add an expression to calculate the due date based on this.
1. Select the document you want to amend, then click Edit.
2. Click the Toolbox menu, then click Add Expression.
3. Click the area on the layout where you want the payment due date to appear.
4. In the Expression Editor window, enter the following expression:
INVOICE.PAYMENT_DUE_DATE <> Null ? INVOICE.INVOICE_TYPE_CODE IN (0,1,2) AND (SALES_LEDGER.PAYMENT_DUE_FROM <> 0 OR SALES_LEDGER.PAYMENT_DUE_DAYS > 0) ? “Payment Due: ” : “”:””
5. Click OK.
6. Click the Toolbox menu, then click Add Expression.
7. Click the area to the right of the first expression.
8. In the Expression Editor window, enter the following expression:
INVOICE.INVOICE_TYPE_CODE IN (0,1,2) AND (SALES_LEDGER.PAYMENT_DUE_FROM <> 0 OR SALES_LEDGER.PAYMENT_DUE_DAYS > 0) ? INVOICE.PAYMENT_DUE_DATE : “”
9. Finally, Click OK.
How to add your payment method and bank details
If you want to show the same payment terms on all invoices, for example, ‘Payment due 30 days from invoice date’, or add your bank details, you can add a text box.
1. Select the document you want to amend, then click Edit.
2. On the menu bar click Toolbox, then click Add Text.
3. Click once where you want the text to appear.
4. Enter your payment terms and bank details, then click a blank area.
5. All done!
Further Information
If you have any questions about this or need assistance, then please contact the GCC Group Support Team on 0345 260 1151 or servicedesk@gccgroup.co.uk
Sage 50 Health Check
GCC are offering a free Sage 50 Accounts Health Check for Sage 50 users.
We are aware that a lot of things may have changed in your business, post-COVID – and we want to make sure that you are getting the most out of your Sage 50 Accounts.
This free 30-minute health check will be via Microsoft Teams, with our Sage consultant – Guy Lester.
This Sage 50 Health check will review:
- the performance, management accounts, reporting, credit control & stock within your Sage 50.
Sage 50
Create a more agile, efficient & modern business with Sage 50 Accounts.
Sage 50 combines the power of desktop accounting with cloud computing, allowing you to access your critical information any time, from anywhere.
The automated data-capture, in-depth reporting, and built-in help & guidance offered by Sage 50cloud accounts makes it an accounting system for the digital age.
There are 2 variations of Sage 50cloud accounts available:
- Sage 50cloud Standard
- Sage 50loud Professional