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.