Reporting - General Ledger Transaction Per Period
Reports generated in Twinfield contain the most up to date entries, which allows you to review your transactions booked, with drill down capabilities into individual transactions, enables adjustments, prepayments and the reposting of values where necessary.
Select icon from the ‘Menu bar’, then click the ‘Reports’ tile.
Select View category under the main heading for ‘General Ledger’.
Select report General ledger balances per period.
The following criteria's can be defined:
- Company
- Reporting Structure
- Period
- General ledger code
- Customer, Supplier, Cost centre
- Provisional/Final
- Rounding
Click onto an amount, choose General ledger transactions. This will display an itemised list of entries.
Click onto an amount, choose General ledger transactions. This will display an itemised list of entries.
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. 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.
Click Export button then select you format from the dropdown.
Click ‘Next’ to run the report.
Design allows you to customise the report based on the original. This is covered in the advanced training course.