Before you begin, make sure you:
Ensure you're working within your Consolidation Working Papers
Have your GRT configured for Balance Sheet accounts (either Balance Sheet only or "Both" type)
Understand which accounts need adjustment and the amounts required
Know whether adjustments are permanent or temporary
Key Concept: Balance Sheet journals carry forward automatically (in the same fashion as a Balance Sheet journal in a company Balance Sheet. If you add £1,000 in January, that £1,000 will appear in February, March, and all subsequent months unless specifically adjusted.
Step 1: Navigate to Balance Sheet journals
Open your Complete Consolidation working papers
If your GRT includes both P&L and Balance Sheet accounts, click the Balance Sheet tab
If your GRT is Balance Sheet only, you'll already be in the correct view
Locate the month where you want to add your journal entry
Step 2: Initiate journal creation
Find the "+" icon in the month column where you want to add the journal (e.g., January 2025)
Click the "+" icon to open the journal creation dialog
The Add Journal popup will appear with fields to complete
Step 3: Configure journal details
Narration
Enter a clear description for your journal entry
Example: "Reclassification Adjustment"
This appears in your audit trail and working papers
Type of Journal
Select "Journal Entry" from the dropdown
This is the only option available for Balance Sheet journals
Tag
Choose from four classification options:
Elimination: For removing intercompany balances
Reclassification: For moving amounts between account categories
Accounting Adjustment: For correcting account balances and GAAP adjustments
Other: For miscellaneous adjustments
Ref No (Optional)
Add a reference number for your internal tracking
Example: "1234" or your organisation's numbering system
Date
Select the appropriate date for this journal entry
Should align with your consolidation period
Reporting Cadence (Automatic)
This defaults to match your consolidation frequency (Monthly, Quarterly, etc.)
You can adjust if needed for specific reporting requirements
Step 4: Create the journal entry
Review all fields for accuracy
Click the green Add button to create the journal
Click Cancel if you need to abort the process
The system returns you to the consolidation view with a new journal column added
Step 5: Enter journal amounts
Understanding the journal layout:
You'll see a new journal column between your standard columns
Each GRT account has input boxes for Debit and Credit amounts
The system follows standard accounting principles for each account type
Account type rules:
Assets: Debit increases, Credit decreases
Liabilities: Debit decreases, Credit increases
Equity: Debit decreases, Credit increases
Entering amounts:
Click in the appropriate Debit or Credit box for your chosen account
Enter the journal amount (e.g., 1000 for £1,000)
The system automatically applies proper accounting treatment
Continue for all accounts in your journal entry
Step 6: Save your journal
Review all amounts for accuracy
Ensure debits equal credits (balanced entry)
Click the Save button to finalise your journal
The journal is now active and will appear in all subsequent months
Understanding carry-forward concept
How Balance Sheet journals work:
January: You add £1,000 to Accounts Receivable
February onwards: £1,000 automatically appears in all future months
Cumulative nature: Balance Sheet positions build upon previous months
Example scenario:
January: Add £1,000 journal → Balance shows £1,000
February: No changes → Balance still shows £1,000
March: Add £500 more → Balance now shows £1,500
April onwards: Balance continues at £1,500
Making adjustments to existing journals
Step 7: Edit journal amounts
Navigate to the month where you want to adjust the amount (e.g., February)
Click the edit icon (pencil symbol) next to your journal
The journal editing dialog opens showing current amounts
Increasing journal amounts:
To change from £1,000 to £1,500, enter £500 in the same accounts
Use the same Debit/Credit pattern as your original journal
Click Update to apply changes
Decreasing journal amounts:
To change from £1,500 to £1,000, enter £500 in reverse
If original was Debit, enter as Credit (and vice versa)
Click Update to apply the reduction
Step 8: Using "Reverse in Next Month" feature
When to use this feature:
For temporary adjustments that should only last one period
Example: March needs £1,800, but April should return to £1,500
How to implement:
Navigate to March and click the edit icon for your journal
Enter the additional amount needed (£300 in our example)
Select the "REVERSES in the Next Month" checkbox
Click Update
Results:
March shows £1,800 (£1,500 carried forward + £300 adjustment)
April automatically returns to £1,500 (£300 reversal applied)
May onwards continue at £1,500
Advanced features
Viewing net positions
Edit any journal entry
Click the "Net Positions" button
Review the Net Position of the Group Reporting Template Accounts dialog
See cumulative debit/credit balances and net positions for each account
This helps track the total impact of all journal adjustments
Managing journal status
Deactivating journals:
Click the tick icon (✓) next to the edit icon
The journal becomes inactive for that month only
Amounts won't appear in consolidation but journal remains in system
Reactivating journals:
Click the tick icon again to reactivate
Journal amounts immediately return to consolidation
Understanding frequency changes
Important note:
If you change from Monthly to Quarterly consolidation frequency
The system shows the last month of each quarter only
It doesn't sum the three months (Balance Sheet is point-in-time, not cumulative)
January, February, March monthly journals where Financial period is → Only March appears in Q1 quarterly view
Journals with nil amounts:
If you reduce a Balance Sheet column to zero, the journal will not appear in the consolidation.
If you need to edit that journal, you have to go to the Journal screen, open that specific journal, and update the amount.
For example, if a journal has an amount of 1,000 in January and you reverse the same 1,000 in February, then from February onwards the amount will be zero and it will no longer show up in the consolidation.
Confirming your success
You'll know your Balance Sheet journals are working correctly when:
Journal amounts appear consistently in subsequent months
Adjustments correctly increase or decrease account balances
"Reverse in Next Month" entries automatically reverse as expected
Your consolidation remains balanced (Total Assets = Total Liabilities + Equity)
Common questions
Q: Why is my journal showing in every month after I created it?
A: This is correct Balance Sheet behaviour. Unlike P&L journals, Balance Sheet journals carry forward because they represent cumulative positions.
Q: How do I completely remove a journal amount?
A: Edit the journal in any subsequent month and enter the full amount as the opposite debit/credit from original.
Q: Can I see the total impact of all my journals?
A: Yes, use the "Net Positions" feature when editing any journal to see cumulative effects across all accounts.
Q: What happens to my journals when I change consolidation frequency?
A: Balance Sheet journals show point-in-time positions, so quarterly view shows only the last month of each quarter.
What's next?
Once you've mastered Balance Sheet journals:
Explore P&L Journals: Learn how income statement adjustments work differently
Master Working Papers: Understand the full consolidation working paper process
Advanced Reporting: Generate detailed consolidation reports with journal details
Audit Trail Management: Track and document all consolidation adjustments
Have questions or need assistance❓
Contact our support team at support@gather.nexus