If you've rounding differences in your accounts, take the following steps to resolve them.
Step 1 — Check opening and closing balances from prior period match exactly
note
Opening balances rolled forward with the opening balances journal are correct to the penny. There are 2 exceptions: LLPs and charity accounts.
For an LLP, check the opening balances manually.
For a charity account, check the opening balances manually and post as a journal.
If you've imported a trial balance from an external source, then we recommend the following steps:
Export the trial balance for the current and prior periods to Excel.
Check the closing balances from the prior period to make sure they match the opening balances from the imported trial balance.
Step 2 — Set the rounding account
In the client, go to the
Journals
tab.
note
If the difference is in the comparative period, then select the
Comparative
sub-tab on the
Journals
tab and make the change to the Rounding Account.
Select the
Rounding Account
ellipsis button.
Select the
Rounding differences
code, if not already selected.
Select
OK
.
Step 3 — Post a small rounding journal
Post a small rounding journal of
£0.60
between the profit and loss account and the balance sheet.
note
For example, you could use the purchases and other creditors codes, if there's a posting to them already.
Step 4 — Ensure the accounts include journals correctly
Go to the
Journals
tab of the client.
Make sure you've marked the checkboxes for relevant journals and that their date is the last day of the accounting period.
If the journals don't have the date of the last day of the accounting period, select
More
to either change the date or clear the checkbox.
If these buttons aren't active:
Right-click the journal, then select
Copy
.
Right-click under the list of journals and select
Paste
, then
Paste
again.
Clear the
Include
checkbox for the original journal.
Step 5 — For group consolidated accounts where the company balance sheet is out of balance
In the consolidated entity, go to
Entity Setup
, then
Entity Structure
.
Select the parent company folder in the
Entity structure
.
Mark the
Round Independently
checkbox.
note
This should be the only entity that you round independently.
Check the other entities in the
Entity Structure
and make sure that the
Round Independently
checkbox is cleared for all the others.
Step 6 — For partnership accounts where you are not allocating profit fully
note
You'll need to set a partner’s account so that any rounding amount of profit split is sent to it. For example, you if you split profit of £13 split between 2 partners equally 1 partner would need to have £6 and the other £7.
Select the
Import Account Assignment
tab, then
Profit Allocation
.
Further steps to round account codes, if steps 1 to 6 didn't resolve the problem.
note
Small roundings from prior periods may have built up to the point where they appear on the report in the current year. You can use the following steps to round an account code independently.
Go to
Financial Period
.
Select
Configuration
, then
Accounts
.
Find and select the account code from the list.
Select
Edit
.
Mark the
Round Independently
checkbox.
Select
OK
.
note
If you round
499.00
,
999.00
and
Suspense
independently you may find this resolves the issue, especially if