This information will help the people who are balancing the books to fully understand how transactions flow between SAM and Xero



Integration

SAMXero
  • Job Costing
  • Stock Control/valuation
  • Labour analysis
  • Work in progress control/Valuation
  • Workshop reporting
  • Debtors ledger
  • Creditors ledger
  • General ledger 
  • Financial reporting
  • Banking and cashbook processing


Transaction and GL Flow




GL Codes


Sales (P&L):

Will increase when the sale is processed in SAM.


Accounts Receivable (Balance Sheet):

Will decrease when payment is processed in SAM or Xero.
 

Payment Clearing (Balance Sheet):

Will increase if a receipt is posted in SAM and then decrease when reconciled in Xero.
 

Bank (Balance Sheet):

Will increase when reconciled in Xero.
 

Payment Clearing Account:

  • The payment clearing account is a holding account for all payments made from SAM.
  • The clearing account code must be selected when reconciling in Xero.
  • Each payment type (Cash, Cheque, Eft-pos) can be linked to a different Xero clearing account GL code.

 

Reversing Journals:

SAM automatically posts two reversing journals (as Xero manual journals) when rollover is completed at month end. This is to account for the movement of stock and work in progress within the month.

 

Stock reversing journal:

This journal gets posted to your “Inventory” general ledger code. The value of this journal is based on the stock valuation as at your SAM rollover.

Work in Progress reversing journal: 

This journal gets posted to your “Work in Progress” general ledger code. The value of this journal is based on the work in progress valuation as at your SAM rollover



Please note that SAM is not a cost of sales system. This is why we use reversing journals to reflect the movement at the end of each month.


 

Expenses:

  • Expenses can be separated by linking a specific general ledger code to a SAM GL code. Every time the customer creates a purchase order with the relevant GL code, it will send the value to the specified Xero code. e.g. Freight (please note, setup is required).
  • Internal customer’s invoices can also be linked to specific Xero codes. This means any time an internal customer is invoiced it will write off the charge of the invoice to the expense code.







Didn’t find what you were looking for? 

Our Support team are here to help, you can reach us by submitting a support ticket

or calling us on 09 583 2455