Cash Book – Post Customer Refunds

Purpose:
For example to correct for an over-payment by your customer, to settle a goodwill discount on a disputed invoice or to settle a credit note for goods or services returned.

Preparation:
Obtain an up-to-date customer list – see List Customers.
Ensure customer details are up to date – see Create & Edit Customer Accounts.
Obtain details of which invoices are being refunded.
Ensure the customer has been issued a credit note for the amount being refunded, if not an overpayment – see Produce Sales Credit Notes.

Processing:
On the main menu click Daybooks > Cash Book > Payments > Sales Ledger.
Match or part pay monies – see Cashbook – Post Sales Ledger Payments form and also Match Sales or Purchase Ledger Transactions for an explanation of Matching.
Click OK to update.

Balancing/Reconciliation:
See Bank Reconciliation.

Reporting:
As required – see List Cash Book Transactions.
Update customer notes as required – see Create & Edit Customer Accounts.

Filing: File customer remittance advices in reference number order by period.

• Bank: Important! – Please select the bank account the payment was made from.
• Date: Date amount paid or date processed by bank – Either: manual entry formatted as DD/MM/YY. Type over the parts of the date you wish to change – the system will skip over the “/” part itself. If the date you enter is invalid; the cursor will return to the start of the date and await a valid entry, or; click on the field to highlight data – white on a blue background – then right click to open the Calendar Menu – see Dates and Calendar.
• Reference: As required – Note that this field cannot be left blank.
• Amount: Actual amount paid.
• Click OK to move on to ‘Allocation’ tab or Cancel to close without action.

• If Payment covers total amount outstanding click check box next to ‘Matched’, otherwise Match payment against line referring to items paid until ‘To allocate‘ is nil.
• If an item is part paid enter the amount in the Matched column.
• Amount paid – the total value of the debit to the sales ledger.
• Find: Click to open form. Enter a string from a reference to find a particular invoice and click OK. The program will search for the entered text string in the Reference Field of a transaction. ‘>’ to the left of the line indicates a matching record.
• Find Again: Search for the next record matching the criterion entered.
• Clear: Clears all matching entries made on this page – allows you to start again.
• Automatch: Matches exact amounts received against sequential invoices starting with the oldest invoice. Will not allow part-settlement.
• Post Unallocated: Post entire amount as unallocated. Warning message box appears – Click Yes to action, No to return to page.
• Notes: Open Notes form and enter text as required. Notes are stored as a permanent record and are specific to a Ledger account or Product or Service. They can be read and updated at any time by any user with access to the company. Entries should ideally show a date and the name or initials of the author.
• Entries will make a NOTES flag visible whenever the Ledger Account/Product is selected.
• Clicking OK: Closes allocation page, updates records, displays transaction number on form. Click Cancel to close without updating.

Search for existing details

Please refer to https://help.prelude.software/knowledge-base/cash-book-post-sales-ledger-receipts/ – bottom of page for details of search facility