Retail Express sends different transaction types to the corresponding areas in Xero. This video explains where to review general journals, supplier purchases, sales invoices and their associated payments after the data has been uploaded.
In this video we review data that was uploaded from Retail Express into Xero through the Xero integration, including reviewing journals.
Chapters
Timestamp | Chapter |
|---|
00:01 | Xero Upload Overview |
00:16 | Reviewing General Journals |
00:45 | Viewing Journal Details |
00:57 | Reviewing Purchases and Bills |
01:28 | Viewing Supplier Invoice Details |
01:59 | Reviewing Sales and Payments |
02:25 | Viewing Sales Invoices |
02:53 | Viewing Payment Details |
Transcript
Retail Express transactions are uploaded to different transaction areas in Xero. Understanding where each transaction type is recorded helps you review the uploaded accounting data and trace it back to its source in Retail Express.
Reviewing General Journals
The following Retail Express transactions are uploaded to Xero as general journals:
- Stock adjustments
- Inter-Outlet transfers
- Cash Up variances
- Petty cash
- Duty on purchases
To review these transactions in Xero, navigate to:
Advisor > Manual Journals
Viewing Journal Details
The Manual Journals screen displays summary information for each journal entry.
Select an account or journal entry to view its detailed information.
Reviewing Purchases and Bills
Retail Express Purchase Orders and supplier invoices are imported into Xero as approved invoices.
The total value of all products on the Purchase Order is uploaded as a summary amount rather than as separate product lines.
Miscellaneous costs associated with the Purchase Order are uploaded as a separate line.
To review purchases in Xero, navigate to:
Accounts > Purchases
Select See All to display the complete list of purchase transactions.
Understanding Purchase References
The Reference column displays the Purchase Order ID from Retail Express.
The Invoice Number field displays the supplier invoice number entered when the Purchase Order was received in Retail Express.
These identifiers help you match the Xero purchase with its original Retail Express Purchase Order and supplier invoice.
Viewing Supplier Invoice Details
Select a supplier invoice to open it and review its detailed information.
The invoice includes the summary Purchase Order value and any miscellaneous costs uploaded separately from Retail Express.
Reviewing Sales and Payments
Retail Express sales are imported into Xero as approved invoices, with their payments allocated to the corresponding documents.
The balance of each invoice imported from Retail Express should normally be zero because the sale and its associated payments are uploaded together.
Debtor and layby movements are handled through account movements so they do not affect the invoice’s final balance.
To review sales in Xero, navigate to:
Accounts > Sales
Select See All to display the complete list of sales invoices.
Identifying Retail Express Sales
The sales summary displays the Retail Express invoice number and the store associated with the transaction.
These details help identify the source of each sales invoice uploaded to Xero.
Viewing Invoice and Payment Details
Select an invoice to open and review its complete information.
From within the invoice, select the payment details to review the payments allocated to that transaction.