Originally written by John Hardwick, last updated Nov 27, 2023, on the Swan Retail knowledge base (FRS).
This training guide details how to match invoices to GRNs and credit notes to RTSs
Click to Download a PDF version of this document
FRS-09. Invoice Matching-140823-105815.pdf
Video
By following this document, you will be able to link a supplier’s invoice or credit to stock within SwanFRS.
The aim of these training notes is to give you a quick reference booklet following the training session, and you are encouraged to make your notes within these pages.
This document covers the very basic process of invoice matching. There are a myriad of permutations and possibilities relating to this not covered by this guide, therefore it is recommended this be the start of your familiarisation process. It is useful to understand the concepts of SwanFRS’s sales, purchasing and stock management. Continue to use the test systems to explore the system and to scenario test.
Invoice / credit matching effectively adjusts the cost value of the stock in the system and therefore affects margins of sales order linked to that stock.
When linked to certain accounts systems, the process generates an ‘authorisation to pay’ record in the third-party accounting application, but does not process the payment.
It is only possible to invoice match once per stock item, the item must have been GRN’d into stock before the invoice can be processed.
Similar functionality existing for credits, the stock must have been returned by the RTS process before the credit note can be processed and only one credit note per stock item is possible.
The exception to this rule is the ancillary invoice functionality, whereby stock and or services can be linked to an invoice pre or post GRN / RTS as many times as is necessary.
All cost changes are recorded, SwanFRS records the operator date and time the cost price was changed.
Invoicing
From a SwanFRS perspective, an invoice is a bill received for goods received into stock via the GRN process and requires the supplier to be configured to process invoices.
Goods received for non-matching suppliers or via the write-on process cannot be matched
New Invoices
This routine allows new invoices to be registered.
Menu Location: Accounts > New Supplier Invoice
Invoice Header
-
Supplier - Only suppliers marked for invoice matching are listed.
-
Invoice Date - The date of the invoice - This is not today’s date
-
Internal Reference - Your reference
-
Invoice Number - The supplier’s reference (duplicate checks exist)
-
Comment - Optional Comments
-
Currency - Optional if the supplier is not base currency
-
Exchange Rate - applicable if non-base currency invoice
-
Invoice Total - Total value including discounts and taxes not only goods & services
-
Click ACCEPT when ready to proceed.
-
Click EDIT to change header
-
DELETE, removes invoices raised in error
-
Variances in the retailer's favour are showing in green, overcharges etc shown in red.
The invoice has three sections
-
Header
-
Products
-
Additional charges
Linking Stock
To link stock to the invoice, click the + button.
-
Click FIND to search for stock receipted (GRNd) and not paid for from the specified supplier.
-
Click ADD GOODS to associate selected stock to the invoice.
-
Filter list by Purchase Order Number or Delivery Note reference.
-
Per Line
-
Specify Quantity being charged for, line cost, rate of Tax individually or use the A/N check boxes
-
Additional Charges
Optionally add invoice extras, such as a delivery charges, import duties to the invoice via the ADD-ON COST button.
-
Description - Specify what the charge is
-
Cost - How much is the charge
-
VAT Rate - What is the rate of tax
-
Cost Location - Which location (cost centre) is it appliable to.
-
Nominal - Where is the cost to be allocated.
-
- Tick to save the details and add a row, Cross to abort
Click COMPLETE to finalise the invoice, or CLOSE to leave authorisation for another day.
Completing
Clicking COMPLETE produces the following page
-
COMPLETE will only operate if invoice total matches goods and add-ons plus any taxes indicated
-
CANCEL aborts the completion process and allows further modification of the invoice
-
SAVE is used to record changes and continue with another action.
-
EDIT VAT VALUES allows for variances of tax values SwanFRS has calculated to those on the invoice to be adjusted
-
Can change Due Date, Settlement Dates, Settlement Discounts and / or set a ‘held’ reason.
Once completed, and if linked, the invoice will be sent to an account's package for payment.
SwanFRS will automatically adjust stock cost values to those specified within the invoice and adjust profit values in both SwanFRS and any linked accounting package, even if the goods are now marked as delivered to the customer.
Finding Invoices
This routine allows invoices already registered in SwanFRS to be found and where necessary progressed.
Menu Location: Accounts > Find Supplier Invoice
-
Use search criteria followed by FIND to list matching invoices
-
Click on Supplier to view supplier details.
-
Click on Invoice Number to view the invoice details.
-
Use checkboxes to include processed and / or held invoices.
Credits
The credit matching system replicates the invoice matching system in operation and design, with the ‘invoice’ being replaced with ‘credit’.
For goods to appear in the stock pick list, they must have been confirmed as collected via the Supplier Return To Supplier procedure.
Menu Location: Accounts > New Credit Note
Menu Location: Accounts > Find Credit Note
Credits generally reduce the cost of paid for stock.
Ancillary Costs
Ancillary costs are an optional feature in SwanFRS allowing the entry of miscellaneous invoices for both goods and services which can be linked to any product, with costs being distributed where appropriate across these goods.
Menu Location: Accounts > New Ancillary Invoice
-
Supplier - Choose an product or service supplier from the list.
-
Invoice Date - The date of the invoice - This is not today’s date
-
Internal Reference - Your reference
-
Invoice Number - The supplier’s reference (duplicate checks exist)
-
Comment - Optional Comments
-
Currency - Optional if the supplier is not base currency
-
Exchange Rate - applicable if non-base currency invoice
-
Invoice Total - Total value including discounts and taxes not only goods & services
-
Cost Type - Choose one of the 5 prespecified analysis types.
-
Click ACCEPT when ready to proceed.
-
Click EDIT to change header
-
DELETE, removes invoices raised in error
-
Variances in the retailer's favour are showing in green, overcharges etc shown in red.
Linking Stock
To link stock (or services) to the invoice, click the ADD GOODS button.
-
Use any combination of tabs and search filters to find the stock and / or services, then click FIND.
-
This search replicates the Warehouse > Search Stock functionality.
-
An Ancillary invoice relate to stock / services from any supplier.
-
Use the A/N checkbox to select items, then click ADD GOODS
-
-
COMPLETE is used to finalise the invoice.
-
Click EDIT to amend the invoice header.
-
Click DELETE to remove invoices raised in error or no longer applicable.
-
The ALLOCATE COSTS enables the operator to assign a cost value to selected lines.
-
Specify which lines are to b financially adjusted
-
Specify a cost value
-
Specify how the selected lines are to be adjusted
-
Ratio by Quantity, Current Cost, Goods Cost or evenly across the selected lines
-
-
Click UPDATE to apply
-
-
The VAT allows VAT distribution across selected lines
-
Specify which lines are to b financially adjusted
-
Specify a Vat Rate
-
Click UPDATE to apply
-
-
Use the DELETE GOODS to remove items previously added to the invoice to be removed from it.
-
ADD GOODS allows new items to be added to the invoice.
-
line items can be edited () and removed () individually
Click COMPLETE to finalise the invoice, or CLOSE to leave authorisation for another day.
Completing
Clicking COMPLETE produces the following page
-
COMPLETE will only operate if invoice total matches goods and add-ons plus any taxes indicated
-
CANCEL aborts the completion process and allows further modification of the invoice
-
SAVE is used to record changes and continue with another action.
-
EDIT VAT allows for variances of tax values SwanFRS has calculated to those on the invoice to be adjusted
-
Can change Due Date, Settlement Dates, Settlement Discounts.
Once completed, and if linked, the invoice will be sent to an account's package for payment.
SwanFRS will automatically adjust cost values to those specified within the invoice and adjust profit values in both SwanFRS and any linked accounting package, even if the goods are now marked as delivered to the customer.
Find Ancillary Invoices
Menu Location: Accounts > Find Ancillary Invoice
-
Use search criteria followed by FIND to list matching invoices
-
Click on Supplier to view supplier details.
-
Click on Invoice Number to view the invoice details.
-
Preregistered indicates an expected invoice raised when the goods were ordered.
-
-
Use checkboxes to adjust which invoices are to display.
Miscellaneous Costs
Menu Location: Warehouse > Search Stock
If the supplier is not included within invoice matching and subject to permission, it is possible to adjust the cost of an item via the stock detail page.
Use the search stock routine to find the appropriate stock item, then click AMEND.
In the first column, specify the new cost price and a reason for the change.
Click UPDATE to confirm the change.
Files from the Confluence page
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article