1. Home
  2. Knowledge Base
  3. Debtor Management
  4. Invoices and Payments (Debtors Module)

Invoices and Payments (Debtors Module)

In Abtrac invoice payments and outstanding accounts can be managed independently from your accounting software with our optional Debtor Management module.

You can record invoice payments, account for write-offs and adjustments, and report on your debtors from this add-on module. When combined with the Abtrac Accounts link payments can sync automatically.

Debtors Management > Invoices and Payments

From Debtor Management >> choose Invoices and Payments.

Here you can view the invoices with respect to their payments.

Managing unpaid invoices: Grouping and Sorting options

The invoices and payments screen optionally shows all the invoice, client and project information listed further below in this article, and also outline here: User Control Settings: Debtors – Invoices And Payments

You can optionally view invoices within a selected date range, see only those that have been uploaded to your accounts, and only view committed invoices. All the column options can be filtered, including by client owner, job owner, and office.

You will only see unpaid invoices by default

The Invoices and Payments screen filters by the ‘Paid’ column, and will show only unpaid (‘Unchecked’) invoices by default. You can set it to show all (leave blank) or only paid (select ‘Checked’) invoices.

Preview Invoices

Click on any invoice number to preview the invoice.

Go to Invoices

Click on any invoice number to view all the invoice details from the Invoice Management screen.

Clicking on the ‘Print Results’ button will give ‘Invoices Report’. This contains the invoiced and outstanding amounts for the current selection.

Export to CSV

Chossing export to csv will export a tidy copy of the current onscreen invoice payment information.

With a subscription to the Abtrac accounts link you can also update payments back into Abtrac from your accounting software. (This is a paid add on to your subscription)

Clicking on update payments gives the following prompt to check your settings before proceeding.

Any new payments are automatically recorded against the relevant invoice with a preset comment. Those invoices paid in full are also automatically marked and a paid in full date is applied.

A confirmation of the number of attempted and successful payment matches is shown once the sync is completed.

Please note when using the update payments option any subsequent manual adjustments or credits from your accounting system will not be re-synced and applied to Abtrac once a payment has been synced.

Only payments, not adjustments will sync automatically

Please note when using the update payments option any manual adjustments or credits from your accounting system will not be re-synced and applied to Abtrac. It’s only true payments that will synchronise. In the example below the second invoice payment line has been added manually.

Adjustments for small balances

Occasionally you may find invoice payments and amounts vary between Abtrac and your accounting system by one or two cents.

This is usually due to an underpayment by the client, or sometimes it can be difference in the invoice tax, invoice total or invoice line calculations, typically when rounding or truncating to 2 decimal places, either before or after calculating tax inclusive totals. The rules here can vary between systems.

Choosing Adjustments for small balances records a journal adjustment against invoices where the payment for your accounts is over or under the Abtrac invoice calculated total by a few cents.

Choose the Adjustments for Small Balances option in the menu

Select an amount to filter out any invoices with unpaid values of greater or lesser amounts.

All unpaid invoices in the system will have an adjustment applied.

e.g. choosing adjust by (+/-) $0.0 will apply the adjustment to any invoice records with a Still owing/Paid balance of -$0.02 or $0.02

You cannot choose to apply the adjustment to selected invoices, it will process adjustments for all invoices that meet the criteria selected.

When completed a pop-up will show, confirming the number of adjustments processed.

For every adjustment a journal line is added as an invoice payment, it includes the deault adjustment comments and a log of the user who processed the change.

Recording Manual Payments (and adjustments)

To record an invoice payment, click the button on the corresponding invoice row.

From the ‘Record Payments’ pop up, you could choose to ‘Leave Blank’ the ‘Payment Date’ from the dropdown menu . With this option, you can manually enter a date for every new line added.

Or else, choose the ‘Use Today’s Date’ option to automatically add today’s date to the ‘Payment Date’.

You can also check the tick box to ‘Prompt for Payment Receipt’.

There are four payment events to choose from: Payments Received, Uneconomic Amount Written Off, Journal Adjustment and Discount Given. These four options are then used in debtor reporting.

You can also enter detailed comments with each payment event. You will need to save your entries before closing this screen.

‘Date Paid in Full’ will be automatically filled in with the latest/most recent payment event date and the ‘Paid in Full’ tick box checked, once the payment(s) equals the invoice amount.

This date can be reset or changed, by editing the ‘Payment Date’ and is used as the date for payments in debtor reporting.

Payment receipts

Once paid in full you will be prompted to print a receipt if you have checked the ‘Prompt for Payment Receipt’ tick box.

You can also manually create payment receipts for any invoices paid in full by choosing the printer icon in the record payments screen.

When printing receipts you can optionally add a comment to the receipt that is generated.

A preview of your receipt document is loaded and can then be downloaded and shared with the client using your email application (outside of Abtrac)

An example of the standard invoice payment receipt template is shown below, instructions on how to customise your receipt template are further on in the admin section this article. Click here to jump ahead.

Admin settings for recording invoice payments

Customising onscreen options – User Control Settings

Like most screens in AbtracOnLine, you can change the display order of these fields from Administration >> Settings >> User Control Settings >> choose ‘Debtors – Invoices and Payments’ page.

See all the options here: User Control Settings: Debtors – Invoices And Payments

Customising payment receipts

Creating/choosing a Receipt Template

From Administration >> Settings >> Invoice and Other Office Settings > choose Invoice, Account Rendered, Purchase Order, and Receipt Templates

Click on the edit button for the Default Receipt Template. This will take you to the Report Designer screen with the Receipt Template created from Abtrac.

Click on the ‘+’ button to add a new report template.

You can clone this template from the existing template and give it a new name. It is always best to keep the original template as such and clone other templates that you use from it, so that there is always a back up template.

This article outlines how to use the Abtrac report design to modify your invoice templates (the process is similar for invoice payment receipt templates)

An example of the standard invoice payment receipt template is shown below.

Abtrac KB# 2045

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support