The Extended Trial Balance function allows you to review your transactions booked, with drill down capabilities into individual transactions, enables adjustments, prepayments and the reposting of values where necessary.

Click ‘Financial Professionals’ from the menu bar.
clipboard_ee08ff67b4d7b7c26bb73a5410495a95e.png

Select option Extended trial balance.

clipboard_e57654e222b54c59bd4c01a4fec039104.png

The following criteria's can be defined:

  • Company
  • Reporting Structure
  • Period
  • General ledger code
  • Customer, Supplier, Cost centre
  • Provisional/Final
  • Rounding

clipboard_e2b1cc0e473b1a1a4bcc0446a641a21c5.png

Click onto an amount, choose General ledger transactions. This will display an itemised list of entries.
clipboard_ee5b703d819ce8283cf8c42b450ea6dcc.png

The following tasks can be performed from this window:

  • View Transactions: Drill back to original posting
  • Adjust: Amend the transaction via a journal or opening balance Journal
  • Repost: Move the full value of the line to another nominal via a journal, an opening balance journal or a year end journal
  • Spread across Periods: Prepayments - Spread a transaction over various periods.

Spread across Periods

From the General Ledger Transactions report, click onto the amount and select  'Spread across periods'. A separate window now opens where you can define how to spread the transaction. 

clipboard_eb294cf5f1511d7ab10166ceb3b723dd4.png

Select 'Spread across period'. In the 'Spread to' area enter the general ledger account (i.e. Prepayments) to contra out the original transaction. Select 'Spread type' 'fixed number of periods' and enter the number of periods.

clipboard_e04813af17b29d7c24f9ca975df1854c0.png

Click 'Next' to view the posting schedule.
clipboard_ecda2438ce18dd36aedce19dc90fca265.png

Related documents

Cheques and Paying-in slips
Cheques and Paying-in slips.
Twinfield: Twinfield Analysis Consultancy (10091307)
This document outlines a training course on Twinfield accounting software, designed for Twinfield partners and subscribers. The course, lasting up to 3 hours, focuses on enabling participants to leverage their Excel expertise to manipulate TwinCube data for creating comprehensive financial reports. Key objectives include processing transactions and searching via the reporting module. The session covers various topics such as data cube management, Excel formula building, and conditional formatting. Attendees must have advanced Excel skills and their own devices to join the session, as the course is tailored for Microsoft Windows users.
Twinfield Consultancy (10093303/10080551)
This document outlines a consultancy service for Twinfield users, targeting both partners and subscribers. It emphasizes collaborative sessions aimed at improving operational efficiencies and best practices through tailored advice and process reviews. Conducted online or onsite over two 3-hour sessions, the consultancy covers topics such as reporting, VAT reporting, and reconciliations. Attendees are expected to have a solid grasp of double entry bookkeeping. Additional resources, including eLearning courses, videos, and webinars, are provided for further learning.
Twinfield: Integration Consultancy (10095230/10095228)
This document outlines a consultancy-led course focused on the Twinfield accounting software, designed to assist businesses in managing their financials effectively. The course consists of four interactive sessions—each lasting three hours—covering navigation, invoicing, credit management, transactions, and reporting. Aimed at Twinfield partners and subscribers, participants are expected to have a good understanding of bookkeeping principles. Additional resources such as eLearning courses, videos, and webinars are also provided to enhance learning. The maximum group size is six delegates.
Twinfield: PM Integration Consultancy (10091304/10091303)
This document outlines a training course for Twinfield accounting software users, focusing on its integration with CCH Central. The course consists of four sessions, each lasting about three hours, aimed at enhancing attendees' bookkeeping skills and knowledge of both systems. Key objectives include familiarization with CCH Practice Management and Twinfield, as well as hands-on experience with financial processes such as invoicing, bank transactions, and VAT reporting. Prerequisites include a good understanding of CCH Central and appropriate permissions. The course is intended for Twinfield partners and subscribers, with a maximum of six delegates per group.