GL Report List Menu Account List General Ledger>Reports>Report List Report on all general ledger accounts and the structure path which have being added to the general ledger Setup.  This is a list of all the accounts Accounts can be sorted out according to the user’s preference before they are generated Sort By Sort the report by selecting one option from the drop-down arrow. Options area: by Code, Description, Group Code or Bin Location Sub Sort Select a sub sort by Code from the drop-down menu to narrow down the search, select from Description, Group Code or Bin Location Account Type select account type from the drop-down arrow Division If you have Divisions, this will add Divisions to the report. Region If you have Regions, this will add Regions to the report. Branch If you have Branches, this will add Branches to the report. COS Link Balance Enquiry General Ledger>Reports>Report List This Report has been modified, will open on chrome and edge. has no export button as yet but can be copied to excel. Balances by period for year Financial Year  Report that allows the user to check the performance and balance of the subaccounts  Select account from which the report will run from and the account to Account From / To Select the account from which you want to run the report from and to. Financial Year select the year for running the report  Display Type to select the type of display form the drop-down arrow BankIt Report General Ledger>Reports>Report List GL Bank Accounts Choose the account you want to run the report for. Date From / To Choose the date range for which you want to view the report from / Select a date range of when you want to see up to on the report. Processed Select weather you want to run the report for Processed or unprocessed transactions or both. Transaction Type Select the type of transactions you want to run the report for. Cash Book Report General Ledger>Reports>Report List Cash Book Report printed from the Cash Book not from the Transaction table.  Bank Account Select the bank account for which you would like to run the report. Date From / To Choose the date range for which you want to view the report from / Select a date range of when you want to see up to on the report. Select Select whether you want to pull a report for Posted transactions, Transactions still in preparation or both. Sort By Sort the report by selecting one option from the drop-down arrow. Options area: by Code, Description, Group Code or Bin Location Select All Select all filters  Include Division Include Division in your report Include Region Include Region in your report chkShowSplit Cash Flow Report General Ledger>Reports>Report List Cash flow is a financial statement that shows how changes in balance sheet accounts and income affect cash and cash equivalents, and breaks the analysis down to operating, investing, and financial activities. The user has to select the Year, From Period and To Period in order to generate a report Year Select the year you would like to pull a report for From Period / To Period Select the from and to period for your report. The From  Period will always be the first of the month you select and the To Period will always be the last day of that month. Customer Link Financial Performance General Ledger>Reports>Report List Customer Link financial performance report monthly Debtor From / To Select a Customer/Debtor you wish to view the report from / Select the Customer/Debtor you wish to see up to in the report. Year Select the financial year you are running the report for  From Period / Period To Select the period From and the period to from the drop-down arrow Division If you have multiple Divisions, by selecting this will add this column to your report. Sort By Sort the report by selecting one option from the drop-down arrow. Options area: by Code, Description, Group Code or Bin Location Division or Region Select if you are wanting to pull your report by Division or Region Account Level Region If you have Regions, this will add Regions to the report. Excl. Customer Zero Customer By Column Export Bank Manager Data General Ledger>Reports>Report List Pressing continue will download the report Financial Performance by Cost Centre General Ledger>Reports>Report List Year Select the financial year you are running the report for  Period From / Period To Select the period From and the period to from the drop-down arrow Cost Centre Select which cost centre you want to enable for division and region. Division and region is disabled until a cost centre is stipulated Account Level Select the level that you want to report on, the lower the number the more roll up will occur.  Default is always the last level Budget Type Sort By Sort the report by selecting one option from the drop-down arrow. Options area: by Code, Description, Group Code or Bin Location Show Zero Month Budget Show Variance Show Prior Year Show Budget Financial Performance by Period General Ledger > Reports > Report List View a year of Financial Performance per period in one report, one can also drill down on the values to the detail  Report is also known as Financial Performance / Income Statement or Profit and Loss Report criteria defined Budget Type View the budget or the revised budget for this report Budget is the default Cost Centre Select which cost centre you want to enable for division and region Division and region is disabled until a cost centre is stipulated Division Run the report for a specific division Region Run the report for a specific region Year From Select the year from to start your report Period From Select the period from which is derived from your year from Year To Select the year To for the end of your report Period To Select the period from which is derived from your year To Period Replace Enable period replace so that your budgets replace the months that are still to come. Great report if you're looking at the whole year and you still have a few months to go to the end of the financial year.  Period From Select the period from that you want budgets to replace actuals Period To Select the period To that you want budgets to replace actuals Account Level Select the level that you want to report on, the lower the number the more roll up will occur.  Default is always the last level Sort By Allow the report to sort by General Ledger code or by General Ledger name Period Name These are three customizable names to run reports, mainly used in the dairy farming industry. Branch Filter the report by branch Show Prior Year Show the prior year for the same time in that period Show Zero Enable show zero to show all accounts that have not had a movement in them within the period that you have selected Operational View This is a great report for operational managers, it splits the profit and loss into two versions, operational profit and loss and then general profit and loss. There is a tick on each ledger account to enable the ledger account to be in the operational view Show Budget Show the budget total at the end of the report Shows total variance between actual and budget Month Budget Show the monthly budget Show Variance Show the variance between your actual and budget per month Show Category Show the category of each ledger account Good to have when you're exporting and want to summarise by category Show Financial Position Show the financial position / Balance sheet at the bottom of the profit and loss report. This will show as a monthly movement with each month. The report shows the opening balance sheet balance and closing balance sheet balance with the movement in between Show BS show zero Show all accounts in the balance sheet that have not had a movement in that month Report example The report allows for drill downs to source data Click on a value to transaction detail Click on the Date for Document T-Accounts debit and credits Click on the Document number to view the source document Date shows document GL transaction detail Click on the tab for T-Account view Click on the document number to view the source document Show Profit and Loss and Financial Position Display both profit and loss and financial position in one report by selecting two ticks. The Financial position will show at the bottom of the report Financial Performance Summary Report General Ledger > Reports > Report List Gives a monthly to yearly summary per financial period of Turnover less Cost of sales giving Gross Profit plus Income less expenses to Nett Profit.  Can also be viewed as a summary income statement.  Income statement report shows an income statement for the selected month or a financial period The user has to select to generate a report or graph report type then select the following from the drop down arrows Options Tab has one button Recalculate button to recalculate the report Financial Performance with Cost Centres General Ledger > Reports > Report List This is a financial performance report with cost centres and can be printed on screen to view financial performance with cost centre analysis. Before printing the report, the user has to select from the following Year to select from the drop down arrow To Period select From period and To period from the drop down arrow Branch to select branch from the drop down arrow From Period select From period and To period from the drop down arrow GL Group to select general ledger group from the drop down arrow Account Level Select the level from the drop down arrow Region or Division Select either Region or Division General Ledger Budget Summary General Ledger > Reports > Report List This report shows what the budget figure is, per ledger account, per financial period, setup under the GL activity budget setup.  Account From  to select the account from which the report will run from Account To to select the account from which the report will stop at, to limit the report run Region Division From Year / To Year to select the year from and the year to from the drop down arrow  From Period / To Period to select the period from and the period to Account Type Budget Type Show Zero Select Select either account code and account name or both GL Cashbook Recon Report General Ledger > Reports > Report List This report looks at unposted cashbooks, journals and documents which affect the bank and put onto a report with cashbook balance forward and all transactions which would affect the bank  This is a GL cashbook recon report Bank Accounts to select the bank account from the drop down arrow To select the Year From and Year To for generating the report To select Period From and Period To for generating the report Sort By to sort the report by selecting from the drop down arrow GL Cashbook Report General Ledger > Reports > Report List Lists all transactions by a specific bank account and also shows whether the transaction has been reconciled or not, gives the opening and closing balance based on the date selected.  This is a report that lists all transactions by a specific bank account and also shows whether the transactions has been reconciled or not.  Account to select the account from the drop down arrow  Division to select the division from the drop down arrow Region to select the region from the drop down arrow  From Year to select the year from which the GL cashbook report will run from and year to, for limiting the report run From Period to select the period from which the GL cashbook report will run from and the period to, for limiting the report run Sort By to sort the report by selecting from the drop down arrow GL Journal Report General Ledger >Reports >Report List This report is a combination of multiple journals that have being posted put into one report with debits and credits.  It will show the user which journal the transaction came from.  Journal report provides a summary of general ledger transactions sorted by a variety of user defined criteria The report will allow you to choose different criteria’s  Select Posted under Journal Status  Take your date from far back  If you want to see the additional notes on the journal lines, tick the Additional Comments.  Journal No. enter journal number to view a certain detailed journal report Journal Status to select status from the drop down arrow Date From / Date To to select the date from and the date to for running a report Order By to select order by, from the drop down arrow Detail to run the report by either detail or summary from the drop down arrow Additional Comments tick the box to include additional comments on the report GL Transaction Report General Ledger >Reports >Report List Full transactional history of all postings in all ledger accounts with the opening and closing balance per Ledger Account and movement between specified dates.  This is a full transactional history of all postings against all ledger accounts with the opening and closing balance per Ledger accounts and movement between dates specified Ledger Accounts select the start account and the end account for the report Periods select the year, period from, period to, from the drop down arrow Options select sheet type, sort by and sub sort by options from the drop down arrow Account Group   From Account To Account From Year From Period To Period Sheet Type Sort By Sub Sort By Division Region Projects if these options are selected, the accounts with no transactions and projects will be included in the report Trail Balance Format This button allows you to run the report in a Trial Balance Format.  i.e., If the account has a debit opening balance, the report will open with a positive value.  It will add each debit transaction and subtract each credit transaction. If the account opening balance is a credit, the report will reflect each asset account as a positive opening balance if the opening balance is a debit.  It will also reflect each liability account as a positive if the opening balance is a credit. Show Division Print Accounts if these options are selected, the accounts with no transactions and projects will be included in the report Show Customer Link Show Region Show CO Code GL Transaction Report (No1) General Ledger >Reports >Report List Full transactional history of all postings in all ledger accounts with the opening and closing balance per Ledger Account and movement between specified dates report No1 Account Group   From Account From Year From Period Sort By Division Sheet Type To Account To Period Sub Sort By Region Trial Balance Format Tick Projects Tick Exclude Control Accs Tick With No Transactions Tick Include Footer Note Tick Summary Report Tick Show Customer Link Tick Show Division Tick Show CO Code Tick Show Region Tick GL Transaction with Balances (No2) General Ledger >Reports >Report List This report is similar to the GL Transaction Report (No1) except that the income statement values show the opening balance from Year 1 of operating the package.  It does not reset to zero on each financial year like the GL Transaction Report (No1).  From Account   From Year From Period Sheet Type Sort By Division To Account To Year To Period Sub Sort By Region Project Projects Tick Show Division Tick With No Transactions Tick Show Region Tick Show CO Code Tick GL Tree Report General Ledger >Reports >Report List Gives a report using the tree structure of the general ledger setup to find the values of all children account values under the main structure.  The report that gives a tree structure of all general ledger accounts. Select one of the accounts first and generate the report to get detailed view of the select account report. Period: this allows the user to select the year and period for running the report Ledger Graph General Ledger > Reports > Report List Displays a line or bar graph of all values of debits less credits depending on the specific general ledger account.  Day intervals can be specified.  Post Dated Cheques General Ledger >Reports >Report List This report shows all post-dated cheques that were selected by a tick to show up in this report. Bank Account   View Periods From Year / To Year From Period / To Period View Criteria Sort By Select select either summary or detail Project Group Profit and Loss Report General Ledger >Reports >Report List Gives an income statement report based on the project group selected.  Project groups can have many project lines within it.  This is an income statement report based on the project group selected Note: If the report returns zeros. Then please check that the GL Account setup (Sales Accounts) has a linked cost of sales account. From Year / To Year To run the report, the user has to select the year from which the report will run from, and the year to From Period / To Period Select the period from and report to Project Groups Select group from the drop down arrow Decimal Place Project Line Profit and Loss Report General Ledger >Reports >Report List Shows an income statement report based on the project line selected.   Project lines are singular projects setup and are not part of a group.  The report comes in summary and detail From Year / To Year To run the report, the user has to select the year from, and the year to From Period / To Period select the period from and report to Project select project from the drop down arrow Show Detail Tick the Show detail to have the detail report or Remove the tick to run the summary report Report is found under General Ledger Summary report Detail report Report Displaying All Unprocessed Documents General Ledger >Reports >Report List Sales Profit Analysis General Ledger >Reports >Report List From Year / To Year   From Period / To Period Division Region Sales Group Include Margin Tick Sort By Statistics Report General Ledger >Reports >Report List This report shows statistics for a certain period on basic information  It’s a report on collection of methods used to process accounts amounts of data and report overall trends. Date From / Date To To generate the report, the user has to select the date from which the report will run from and the date to Select Ticks select the debtors, creditors, job, time sheets, assets or select all of them. Trial Balance By Period General Ledger >Reports >Report List View a year of Trial Balances per period in one report, one can also drill down on the values to the detail  Year   From Period / To Period Sort By Incl. Category Incl. Type Show Open Bal Summary View the Transaction Lines for a Specific Document General Ledger >Reports >Report List View the transaction lines for a specific document type and date range.