Customer Activity

This shows the trading history between you and your customer.  It shows the customer’s credit limit, the balance owed, as well as the total they have paid and the turnover for the year.

Each line represents a transaction such as an invoice or a receipt.

To view the activity, click Customers, either highlight the required customer and click Activity at the top of the screen or double click the required customer record Activity.

Viewing the Customer activity

A/C  – This shows the customer account reference.

Name  – This shows the name of the customer.

Credit Limit – This shows the credit limit entered in the Credit Control tab.

Balance – The current balance of the customer account.

Amount Paid– Total payments made by the customer.

Turnover YTD – The year to date turnover value for this customer. This value is net of VAT.  The YTD figure is taken from the Sales tab and clears when you run the year end routine.  You can manually amend this value in the Sales tab.

O/s Only – If ticked, the window will update to display outstanding transactions only. Untick to show all transactions.

No – the number of the transaction.

Type – The following transaction types may appear:

SI  =  Sale Invoice

SR = Sales Receipt

SC = Sales Credit

SA = Sales on Account

SD = Sales Discount

SP = Sales Payment

Date – The date of the transaction.

Due on – The transaction due date.

Ref.  – The transaction reference.

Exchange Rate  – The exchange rate of the transaction (will not show if foreign currency not set up)

Details – Any details entered for the transaction.

Amount – The value of the transaction.

O/S – The amount of the transaction that is still outstanding.

TIP – *=Transaction is fully outstanding. P=transaction is part paid.

Debit – If the transaction represents a debit, its value appears here.

Credit  – If the transaction represents a credit, its value appears here.


Viewing transactions

Show details – opens a window breaking down any selected transaction into its component parts.  For example, a sales receipt is broken down into the invoices it paid off, and a sales invoice lists any receipts allocated against it.

Hide Details Closes the window showing the detailed breakdown.

View transaction – To view the full details of the transaction, select the required transaction then click View transaction or you can double-click the transaction.

View item – If the transaction was created from an invoice record, to see the related invoice, select the required transaction then click View item.  Alternatively, you can double-click the transaction.

View Bank charges – If you use the bank charges feature, to view any bank charges associated with the customer click View bank charges.

Amending or removing transactions

Edit transaction  – To amend a transaction while in the activity window, click the transaction then click Edit transaction.

Unallocate transaction – If you have posted a receipt or credit against an invoice in error, you can use the Unallocate  transaction option to unlink the transaction.  A sales receipt (SR) becomes a sale on account (SA) when it is unallocated, then it can be allocated against a different invoice.

Delete transaction – To delete a transaction while in the activity window, click the transaction then click the Delete transaction.

Aged balances – At the foot of the window aged balanced appear, broken down into boxes according to the ageing method chosen in Settings > Customer Defaults > Ageing.

If you would like further help with the Customer activity screen or need any other help with your Sage Accounts please contact us

Not all accountants are grey.

Call us now for your FREE consultation on 01691 654545 or click here...