End of Month Cheat Sheet – Syndicators

End of Month Cheat Sheet – Syndicators

Before Starting End of month

  1. Reconcile Xero.
  2. Run Check Balance Report (Finance/Statement/More/Check Balance) and clear up any differences.
  3. Review for any $0 values.
    1. Finance/Transactions
    2. Change date to current month
    3. Click on sale column twice (until lowest figures are at the top of the list)
    4. Review any $0 figures, ensure they are correct
  4. Review report on Step 4 & Step 9.

End of Month Statement Process

  1. Finance – Transaction - Create Statements.
  2. Change Dates to the statement month – Always do a complete month.

  3. Connect to Xero.
  4. Next.
  5. Click Yes.

  6. Step 1 - No Daily Charges – Correct any locations or status on this list, then click “Next”.

    NOTE: THIS IS ONLY USED BY SYNDICATORS IF YOU ARE USING DAY RATES – CLICK “NEXT” IF THIS DOESN’T APPLY TO YOU

  7. Step 2  - Horse Ownership – Correct any ownership issues listed, then click “Next”.
  8. Step 3 - Missing Fields – Add any “Accounts Rec” codes that are missing. Then click “Next” – Ignore any red Accounts (Pay).
  9. Step 4- Expense Confirmation – Select 3 dots on left side and select “Approve All”.

  10. Select the More button, then select “Export All to PDF” from the bottom of the screen and select “Export All”. Review horse expenses and make changes back in the Prism system before proceeding. Then Click “Next”.

    Click “Next”
  11. Step 5 Reversals – Click “Next”
  12. Step 6 Discounts – Review, make changes, then click “Next”
  13. Step 7 Credit – Click 3 dots on left side. Then click “Approve All”. Click Next

  14. Step 8 Interest – Review, Click “Next”
  15. Step 9 Preview Statement – Select the more button and select “Export to PDF” Review Statement Report. Make any changes in the Prism system before proceeding. 


    Click “Next”.

    DO NOT CLICK “NEXT” IN STEP 7 UNLESS YOU ARE READY TO COMPLETE STATEMENTS

  16. Always select “Generate Blank Statement”. Then click “Next”.

  17. Step 10 Email Statements. Select circle on the left side for all statements that need to be emailed. Click “Email”. 

    When Statement email appears. Review then click “Send.

    Click “Ok”. 

    Click “Yes”.

    Click “Next”.
  18. Step 11 Syncing – Finish and Connect to Xero.
  19. Go to Report tab – Email Log – Check any emails that have bounced.
  20. Go to Finance – Transactions.
    Change the date to the month just completed (i.e. 1 Dec 2025 to 31 Dec 2025).
    Go to settings cog on right side and select “Status”.


    Select “Status”

    In status field, select “Pending”

    Ensure there are no items listed – Any transactions listed “Pending” will need to be investigated.

  21. Statement Run is completed.