Supplier Reconciliation and Remittance Advice

Top 

For an alternative reconciliation method see Pay per Invoice ).

 

This report shows all the invoices (bills/GRV's) and  payments.

Supplier statement reconciliations are one of the most important financial controls in any business. They ensure that all sums due to suppliers are accounted for and that they are only accounted for once. Without performing this control, an organisation runs the risk of understating its liabilities and costs but also increases the exposure to duplicate invoices and payments.

 

Go to Supplier > Lookup & Reconciliation, right click on the supplier you want to reconcile and select Reconcile this Supplier, alternatively

Go to Supplier > Enquiries and select the supplier you want to reconcile from the dropdown box.

 

Reconciliation steps.

           Reconcile the account. (See below for detail).

           Print the advice note.

           Process the reconciliation.

           Go to the Completed Reconciliation and do the payment.

                 

Hover the mouse over the different fields on the form. If the cursor changes to a hand (Hand_Cursor) , click to get more information.

AllocatedMod DateRCompCheckboxEdit FilterCalculationsFix Small DifferenceStrict Reconciliation ModeSupplier Statement DateRetrieveRecon Up To This DateSupplier Statement BalanceMake SettlementSettlement DiscountNormalStatusSupplier Advice NoteGridStatusPrint Process ReconciliationCorrectionsChange SupplierChange DescriptionOpen Original DocumentSummary BarSearch RowClear FilterColoured ColumnsModuleDebit CreditAudit No.Document NumberOpen General LedgerSaveSupplier_Recon

 

Menu Items

Description

Save

Save the data.

Process Reconciliation

This will mark the entries as completed. Click on Process when everything is reconciled and the Difference with supplier balance is zero. This will transfer the reconciliation data to the Completed Reconciliation table. See Completed Reconciliations.

Print

Print the data.

Clear Filter

If you filtered the form, the clear filter will clear it.

Open Supplier

Will open the Supplier Form.

Supplier Advice Note

(Remittance Advice)

A remittance advice is a letter sent by a customer to a supplier, to inform the supplier which invoice(s) has been paid.

Print or email the advice note to the supplier.

Show Normal

Only non-reconciled entries will be displayed.  

Reconciled/Not Comp.

Show all reconciled entries that's not completed. It is good practice to click on this button when you start with a new reconciliation.

All

All entries will be displayed, completed (RComp) as well as non-completed.

 

Field

Initial Information supplied by you

Settlement Discount & Amount

The settlement discount % will be pulled through from the Suppliers form.

The Settlement Discount Amount will be calculated from the Amount Payable, this amount can be changed per hand if you so wish.

Make Settlement Discount Entry

An entry will be posted to your supplier reconciliation form, and marked as less discount not on statement.

The Journal entries will be as follows.

 

GL Account    

Description  

Debit

Credit

Creditor Control  

Settlement Discount 3% of $2363.74

70.91

 

VAT Control>VAT Input  

VAT: Settlement discount

 

8.71

Discount from Creditors

Settlement discount 3% of ...

 

62.2

Note:

If you do not want to use the Discount from Creditors account then you can add your own account in the Account Setup. Ensure that it is linked in the Account Options > Account Defaults tab.

Supplier Statement Balance

Type in the balance as shown on the supplier statement.

Reconcile Up To This Date

Type in the date. This is usually the same as the Supplier Statement Date. The date will be different if your GRN date is not the same as the Suppliers Document date.

Supplier Statement Date

The date as shown on the Suppliers statement.

Retrieve

Click on the Retrieve button to display only entries up to the Specified Statement Date.

 

Columns

Description

Date

Purchase Date

Mod.

Module where the transaction came from. [GRV= Goods Received, SJ = Supplier Journal, SPAY = Supplier Payment, RTS = Return to Supplier]

Doc. No.

Internal document number. Click to retrieve the original document.

Audit No.

Click to show the journal entries.

Reference

Suppliers document reference

Debit

Debits = Payments and credits received.

Credit

Amounts you owe.

Status (Reconciliation)

For each entry, choose the relevant Reconciliation Status from the dropdown box. (See options below)

Allocation Note

Note about the allocation.

Allocation By

Employee who did the allocation.

Modify Date

Date it was modified.

RComp

Completed reconciliations. Will be checked automatically after you have processed the reconciliation.

Strict Reconciliation mode will prevent you from changing the RComp. status. You almost never need to change the status and indicates serious problems.

 

Reconciliation Status

Description

Reconciled

Select if the amount corresponds to the amount on the supplier statement

Less payments not credited on statement

Select if your payment does not show on the supplier statement

Pay the RTS (Return to Supplier)

Select if you do not want to deduct the RTS amount from the amount payable, thus paying the supplier

Do Not Pay the RTS

If you want to subtract the RTS amount, thus not paying the Supplier.

Less outstanding invoice

If you do not want to pay invoice

Less goods not received

If you do not want to pay invoice

Minus invoices not due know

If you do not want to pay invoice

If you do not want to pay invoice

If the entries are not applicable for this reconciliation.

 


Form Options and Calculations

Strict Reconciliation Mode

Strict Reconciliation mode must be on. You can prevent accidental deselecting of the checkbox by using your Security Setup.

This will help ensure the integrity of the reconciliation and prevent the printing of the advice note if the reconciliation is not correct.

If the Strict Reconciliation Mode is turned off then there is no check to ensure that the reconciliation is correct.

Mark everything as reconciled up to: "Recon Up To this Date"

Reconcile Up To This Date is the date field at the top of the form.

The reason for this button is to mark everything as reconciled (completed up to this date). You will use this button if you did not reconcile your suppliers, say for the last year or so and you want to start reconciling from now on.

Fix Small Difference < 1

If the difference is smaller than R1 then you can select the Fix Small Difference < 1 button to automatically do a journal entry for the difference.

 

Calculations as done by Smart-It

Reconciliation Balance (Calculated from our balance).

 

This is all the credit amounts for the specific period (Unreconciled (Not Due) is ignored) + Less Outstanding Invoices + Less Goods Not Received + Minus Invoices Not Due  - Do Not Pay the RTS.

Or

Recon Balance = Our Balance - Unreconciled Credits + Unreconciled Debits or Do Not Pay the RTS + all less or minus credit amounts

 

Amount in Dispute =

Less Outstanding Invoices + Less Goods Not Received + Minus Invoices Not Due  - Do Not Pay the RTS.

Difference with supplier balance  

Supplier Statement Balance - Recon Balance (calculated from our balance)  + Amount in Dispute.

If everything is correct the difference must be 0.

Please Note: The difference with supplier balance must be zero. If not, find and correct the fault. If the difference is smaller than R1 then you can select the Fix Small Difference < 1 button to automatically do a journal entry for the difference.

Our Balance on Statement Date

Is the sum of all credits minus all debits (completed and non-completed values).

If you want to compare the value on the grid with Our Balance on Statement Date, click the All button on the menu.

Amount Payable

Is the amount you must pay the supplier, also the amount used to calculate the Discount Amount.

= Supplier Balance - Less Payments Not Credited On Statement or Do Not Pay The RTS

Notes:

There are not supposed to be any unreconciled entries in the reconciliation form. Change the statement date to exclude items that are not applicable for this period.

 

How to handle a supplier invoice which you have not received.

Option 1.

Change the supplier statement balance with this amount. Please use the 'Message on Advice Note' to make a note about the change.

Option 2

Make out a supplier journal and mark it as 'Less Goods Not Received'

 

See also Security Setup if you to restrict access to certain fields. Example if you do not want to change the reconciliation status and the Strict Reconciliation Mode.

 

See also Employees | Security Groups

 

http://bit.ly/SiSupplierRecon