Contact Transactions report

The Contact Transactions report is generated only as a result of drilling down from the Expenses by Contact or Income by Contact reports to see the list of transactions for the individual contact within either of these reports.

Main Transactions report screen for a contact.

What can you see and do with the Contact Transactions Report?

Generate report

The Contact Transactions report is generated showing all transactions for a Contact or just those transactions that make up a specific amount depending on where in the Expenses by Contact or Income by Contact reports you are drilling down from.

 

This report shows either expense transactions or income transactions depending on which report you are drilling down from.

Enter or edit

rep - button - update.png

Choose or update the options by which to re-run the report:

reports - conttrans - fields.png

From

The date you want the report to start from.

To

The date you want to run the report until.

Update

When the details of the report you want to run are entered or updated, click Update to generate the report.

If you are viewing a report produced by someone with the Adviser user role, you may see notes or a summary on the report. You may be able to export, archive or edit the report, depending on your user role.
Reports and budget role comparison

View transactions

Transactions on the Contact report.

Transactions

The list of transactions (any type) shows all amounts for the chosen Contact.

All transactions for a Contact or just those for a chosen month will display depending on the period of the report.

The reference column displays the reference for the transaction or the sales invoice number.

 

Regardless of the date of a transaction, its amount will only be recorded against an account in your chart of accounts once it has been approved i.e. sales invoices or bills that have been approved and are awaiting payment, or expense claims that have been authorised. Spend or receive money bank transactions display immediately.

Select

Individual transaction

Select transaction

Click on the transaction to view the source of the transaction i.e. the invoice, bill, credit note, bank transaction or expense claim.

reports - conttrans - back exp.png

reports - conttrans - back inc.png

rep - button - print.png

Export options

If you have the Adviser user role you will also be able to Save as Draft, or Publish this report and change the default PDF preferences. If you're using Partner Edition your practice logo will display if your Principal has set it up.

Back to [name of report]

Depending on which report you have drilled down from, a link will display to take you back – to either Expenses by Contact or Income by Contact.

Print

Print the report directly from your browser.

Export

Choose where you want to export the report to. You can either view it or save it once it's exported into the chosen format.

Excel

Open the report directly into Excel or save it to your computer and open it from there.

Excel report

PDF

Open the report directly as a PDF or save it to your computer and open it from there. Zero figures will show on the PDF as '-' and do not show decimal places so numbers are rounded for display purposes only. In many cases PDF amounts may not add up correctly due to rounding, but in Xero and other exported formats the calculations are correct.

Contact transactions PDF

Google Sheets

If you use Gmail, you can set up your account to access Google Sheets (Google's document viewer). You can then export the report to Google Sheets and edit, save or share it. You're prompted to log into Gmail (if you're not already) and you're prompted to confirm that Xero is a 'trusted' site each time you start a Google Sheets session.

Google

When you authenticate your connection to Google Drive and export to Google Sheets, a connection is made to your Xero account. You can break the connection at any time.

Disconnect Xero from Google Sheets

Google Help (Google website)