Ways to achieve a journal to a bank account in Xero
Although you can't post a manual journal directly to a bank account in Xero, there are three ways to achieve the same effect.
If you have the Advisor user role, use this page to learn about the alternatives to posting a manual journal directly to a bank account.
Video: Posting a manual journal to a bank account in Xero (2:17)
Bank account balances in Xero are based on the conversion balance, transactions entered into the account (payments entered on invoices and bills, spend and receive money, bank transfers) and reconciled statement lines. Xero doesn’t let you directly code a manual journal entry to a bank account so that auditing and reporting on your bank account is as accurate as possible.
Xero automates journals to the bank account when you add spend or receive money transactions.
You can use a spend or receive money transaction to create the journal side of the entry, then mark it as reconciled for the bank side.
Use the Manage Account menu from any of the bank account screens and select Spend Money or Receive Money.
Mark the transaction as reconciled if you can't import its bank statement line.
Example: sales deposited into bank account
To account for sales of 100 deposited into your bank account, enter a receive money transaction for 100. This will create a debit to the bank account and a credit to the sales account.
Run the Journal Report to see this (and other ledger entries).
You can use a suspense account to:
- journal a large number of entries at once, rather than just one or 2 lines of coding
- show only the movement over a longer period (for example monthly), instead of daily.
Example: many lines of coding
You withdraw 20,000 from your bank account on September 5, 2011 for payroll. You want to code it across 200 separate expense accounts (to itemize by employee).
Set up a suspense account in your chart of accounts.
Create a spend money transaction and code it to the suspense account. This will create a debit to the suspense account and a credit to the bank account:
Dr Suspense 20,000 Cr Bank 20,000
Add a manual journal, coded to the suspense account, to give you the required details for the payroll transaction, like this:
Dr Employee Wages Expense 1 180 Dr Employee Wages Expense 2 220 Dr Employee Wages Expense 3 195 Dr Employee Wages Expense 4… 195 Dr ... ... Cr Suspense 20,000
Alternatively you can import up to 300 lines of manual journals using a CSV file.
Reconcile a transaction without a bank statement by marking it as reconciled if you can't import the bank statement line.
Example: movement over time
For clients who send you spreadsheets summarizing all their transactions once a month, it may be easier to set up their bank accounts as current assets. This will save you the step of having to create spend or receive money transactions, outlined in this example.
Set up bank account as current asset
You have received this spreadsheet summarizing transactions over the month from a client who has one bank account:
Enter a receive money transaction for 788 and code it to your suspense account. It will create this entry:
Dr Bank Account 788 Cr Suspense 788
Add a manual journal like this:
Dr Suspense 788 Dr Repairs 122 Dr Advertising 600 Dr Office expenses 90 Cr Sales 1600
This clears the suspense account and shows the relevant account movements over the period.
You know their bank account balance has increased by 788.
For a bank account with fewer transactions or to show movement in an organization for a period, consider setting up a current asset in your chart of accounts instead of a bank account. You can post manual journals to current asset accounts.
This may work for bank accounts such as term deposits where interest and tax transactions happen once a month or quarter.
If you're using Partner Edition and have clients on a Ledger plan, you may prefer to set up all bank accounts as current assets to reflect movements in account balances over a wider period of time rather than just day-to-day transactions. This also saves having to create spend and receive money transactions.