Generate Journal Entries for Xero
Once you have run your payroll, you can generate a journal entry which you can book into Xero.
- To do this simply log into Xero - https://login.xero.com/identity/user/login
- Select "Accounting" → "Chart of Accounts"
- You can download your chart of accounts by clicking Export
- Go back to Earny
- Click Account on left hand navigation
- Click Account on left hand navigation
- Click on Import Chart of Accounts to start with a base of accounts.
- You can now edit the number and names of each account matching it to the account have in your Bexio Chart of Accounts.
- For example if I want to change the Account Name and Number for AHV, I would click Edit for 2100 Debtors / AHV/IV/EO - Old Age Contribution and change the number from 2100 to whatever number is in my Bexio account and change name to whatever name is in my Bexio Account.
- Once done hit Save.
- Once you've updated all your accounts, select Setting tab and click Edit
- There you can select the format you want. Select Xero
- Click Save.
- Once selected, you can download your journal entries in that format by going to Reports in left hand nav.
- Find the month you want to create journal entries
-
Toggle Paid for the month you want to create journal entries for.
- There will be two download options:
- Choose the 2nd, "Download Journal entry COA" if you have specified a chart of accounts that are specific to your account, we will generate the entries based on those specific chart of accounts.
-
For details on how to set up your specific chart of accounts, please visit "How to set up my company specific chart of accounts"
- You will get a CSV file.
- When accounting journal has been created, you can go back into Xero and Select Accounting followed by Manual Journal
- Select the tab Draft
- Click on Import
- Click Import and upload the journal entry CSV document you downloaded from Earny.
- Click Import
- Click Complete Import
- Review the entries and if all OK Click Post.
