Ø
VIDEO INSTRUCTION - RECONCILING CAPRICORN MEMBER ACCOUNT
Open website http://www.capricorn.coop/
Ø Log on to the site
Ø Go to Reports / Monthly Statements
CLICK the arrow down image ( to download the recent statement )
Ø This will open up the statement that we are going to reconcile

Ø Go to Xero / Dashboard / Capricorn Account

Ø Make sure the opening balance from the statement (pdf) matches 100% to the statement balance in Xero

Ø NOTE: When reconciling Capricorn account – reconcile from the account transaction tab only in Xero

Ø Select and click the box next to transaction. Transaction can be reconciled line by line or several at a time

just click MORE arrow down, select MARK AS RECONCILED.
POP BOX will appear just click MARK AS RECONCILED.

Ø When done and all are reconciled and matches to the closing balance. ( STATEMENT BALANCE OF CAPRICORN IN XERO )
go to Xero / Dashboard /Capricorn / Manage Account / Transfer Money

PAYMENT
FROM: CHEQUE ACCOUNT
TO: CAPRICORN
DATE: LAST WORKING DAY OF THE MONTH
AMOUNT AUD: STATEMENT BALANCE IN XERO
REFERENCE: CAPRICORN “MONTH” ACCOUNT
hit TRANSFER.
FAQ:
Q1: What if the transaction to reconcile does not exist on the account transaction tab in Xero?
A1: Find the transaction in purchases in Xero.
- If the transaction is existing and not yet paid, make payment use the date of transactions, capricorn account and reference – Supplier Name.
- If the transaction is missing, request invoice from the supplier, when receive enter the invoice and make payment
Q2: What will I do to the lines in statement with a debit and credit?
A1: Debit and Credit must be same amount, this doesn’t need to be reconciled.
