Accounting Reports

Accounting Reports

Accounting and tax reports are generated in this application. They can be displayed on screen, saved in PDF or Excel format. 
When the reports are issued in PDF format, you can drill down into the report, showing the transactions that make up the balances. 
To generate the reports, perform the following steps: 
Go to: Administration (Back Office) → General Accounting → Accounting Reports
Select the report you wish to issue by clicking on the report name.
Select the appropriate filters. 
Click on the Show button. 
The following are the reports that can be generated in Novohit:

Report
Description (Report/Field)
Trial Balance
It allows to check that all the debits and credits of the accounting entries have been recorded in the general ledger accounts and reflects their balance. The parameters used to filter the information are:
  1. Year and Month: Enter year and month in YYYYMM format.
  2. Year End Account: Select the fiscal year result account, when the last month of the fiscal year (December) is to be consulted.
  3. Show Auxiliary Acc: Define if the auxiliary accounts are shown or not in the report.
  4. Report Type: select the type of report between:
    1. Summary: shows the information to general ledger accounts.
    2. Detail: Displays the accounts that make up the G/L accounts.
  5. Chart of Account to Use: indicate with which chart of account the report will be issued:
    1. Novohit: shows the information with the Internal Catalog accounts.
    2. Fiscal: Shows the information with the SAT codes assigned to the Internal Catalog.
  6. Report Format: select the type of report between Normal (PDF) or Export (Excel).

Trial Balance by Cost Center
It allows checking that all the debits and credits of the accounting entries have been recorded in the general ledger accounts and reflects their balance by business unit. The parameters used to filter the information are:
    1. Year and Month: Enter year and month in YYYYMM format.
    2. Fiscal Year Result Account: Select the fiscal year result account, when the last month of the fiscal year (December) is to be consulted.
    3. Auxiliary Accounts: Define if the auxiliary accounts are shown or not in the report.
    4. Business Unit: Select by branch, business unit or all.
    5. Report Type: Select the type of report between:
    6. Summary: Displays the information to general ledger accounts.
    7. Detail: Displays the accounts that make up the G/L accounts.

Trial Balance by Comparative Cost Center
It allows to check that all the debits and credits of the journal entries have been recorded in the general ledger accounts and reflects the balance of the account integrated by the balance by Business Unit. The parameters used to filter the information are:
  1. Year and Month: Enter year and month in YYYYMM format.
  2. Fiscal Year Result Account: Select accounting account from the inbox.
  3. Auxiliary Accounts: Define if the auxiliary accounts are shown in the report.
  4. Business Unit: Select by branch, business unit or all.

General Ledger - Transactions by Accounts
Displays debits and credits for each account according to the transactions recorded in the journal by business unit. The parameters used to filter information are:
  1. Account from: Select the account from which you want to show its movements.
  2. Account to: Select the account up to which you want to show its movements.
  3. Year and Month From: Enter starting year and month in YYYYMM format.
  4. Year and Month To: Enter year and month of end in YYYYYMM format.
  5. Business Unit: Select by branch, business unit or all.

General Ledger of Monthly Accounting Entries
Displays the company's operations. The parameters used to filter the information are:
  1. Year and Month: Enter year and month in YYYYMM format.
  2. Report Type: select the type of report between:
    1. Summary: shows the header information of the accounting entries.
    2. Detail: Displays the complete accounting entries chronologically.
  3. Folio Number: Enter the number from which the journal will be printed. 
View Historical Accounting Entries
Displays the accounting entries of the selected month: the parameters used to filter the information are: 
  1. Year and Month: Enter year in YYYYYMM format

Annual General Ledger
Displays debits and credits for each account according to operations by month of the year. The parameters used to filter information are: 
  1. Year: enter year in YYYYMM format.
  2. Folio Number: enter the number from which the analytical annual report will be printed. 

** When generating the report to Excel it is generated under the .xls option.  If you require the file size to be smaller, you should use the "Binary Excel Worksheet" format, which allows you to keep the characteristics of the Excel file, with approximately 10% of the size that is generated under the .xls option.

Once generated, proceed to "Save As" by choosing the .xlsb option as indicated in the image below.



    • Related Articles

    • General Accounting Reports - Catalog

      This application generates the following essential accounting reports: Accounting Catalog (Mexico) or Chart of Accounts (Chile): displays all registered accounting accounts. Links Operational Modules with Accounting Accounts: shows the association of ...
    • Accounting Budget Reports

      This application generates the monthly budget report for the year for each income and expense account. The report can be viewed on screen, saved in PDF or exported to Excel. To generate the reports, perform the following steps: Go to Administration ...
    • General Accounting

      The accounting register in Novohit allows the automatic or manual generation of accounting entries. The process of updating the corresponding accounting accounts allows the generation of accounting and financial analysis reports (Balance Sheet and ...
    • Bank Reports

      This application allows you to generate reports of the transactions of bank accounts used by the company. The reports can be viewed on screen, printed, saved in PDF or Excel. When PDF reports are issued, you can drill down into the report by showing ...
    • Register of Accounting Entries

      In this application, you can enter, modify, delete, update, search and print the accounting entries for the open month and subsequent open months. Go to: Administration (Back Office) - General Accounting - Register of Accounting Entries The initial ...