Want to export your accounting information from TutorCruncher & import that into your Xero account? No problem! This is quick & easy to do, and we'll be going through the steps here on how to get that set up and running in no time.
Firstly, you'll need to export your accounting information into a CSV file from the platform. You can do this by going to System > Export & then choosing 'Accounting'. From here, you can choose the type of information you want to export, whether that's Invoices, Payment Orders or Credit Requests. In this example, we'll be exporting information relating to Invoices.
N.B: Use Invoices (Detailed) as the export type when importing into Xero.
Once that CSV file has been downloaded, you will then need to log into your Xero account. Navigate to Accounting > Bank Accounts, and then choose the appropriate bank account that you want to update with that CSV file.
From here, select the 'Manage Account' tab that is linked to the account. There will be a few dropdown options that show here, and we want to choose to 'Import a Statement' that can be found just under 'Reconcile'.
You'll now be redirected to new page for importing bank transactions. This will give you a breakdown of the different file types that can be uploaded to Xero. Choose the 'Browse' option & then select the CSV file that has just been downloaded from TutorCruncher. Once that's been selected, choose 'Import'.
Once that's been imported, you'll need to assign the different lines of data on the CSV import to specific statement line options in your Xero account which include Transaction Date, Account Code, Payee etc. Once those have been assigned, choose 'Save'.
The final step would be a matter of 'Reconciling' those transactions to update your Xero account. This will allow you to decide whether each transaction is a form revenue, or if it is an expense for your agency. Review your bank statement lines & then match those with your transactions within Xero.
Once you're happy those transactions are linked to the correct client in Xero, click 'OK' in between the two fields. This will then reconcile the imported transaction & update that within Xero