Skip to main content

Balance sheet Journal

Updated over a week ago

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:

  1. Click the tick icon (✓) next to the edit icon

  2. The journal becomes inactive for that month only

  3. Amounts won't appear in consolidation but journal remains in system

Reactivating journals:

  1. Click the tick icon again to reactivate

  2. 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

Did this answer your question?