To view and run the reports of the Money module, go to: Money > Reports of Money.

For details on using the report settings and parameters, refer to Adjusting and generating reports.

The reports for the Money module which you can use in FirstBIT ERP provide you with summary and detailed information on the balances of cash and bank accounts. Also, you can review cash flow forecast and compare the forecasted amounts with actual data.

Report

Description

Balances of Employee Business Expenses

Figure 1. This report shows the balance of the employee business expenses at the selected date. The amounts owed by the entity are shown in round brackets and in red font. The data can be filtered by entity and employee; grouped by employee and currency.

Bank Reconciliation Analysis

Figure 2. This report is available if the Bank Statement Reconciliations option is selected on the Administration > Settings > Money form. For bank accounts with the Reconcile Bank Statements option selected in their master records, the report allows you to analyze the current state of reconciliation of Bank Statements with bank documents.  The data can be filtered by entity, bank account, currency, and reconciliation status.

Cash Flow Statement

Figure 3. The report shows the main components of the cash inflows and outflows:

  • Cash from operating activities
  • Cash from investing activities
  • Cash from financing activities

Cash Asset Balances

Figure 4. For on a particular date, the report shows ending balances of the bank and cash accounts in the accounting currency and in the currency of accounts. The data can be filtered by entity, account, cash flow item.

Cash Flow Analysis (in Accounting Currency)

Figure 5. For any specified period, shows incoming and outgoing cash flows in accounting currency by cash flow item for each cash and bank account. The data can be filtered by entity, account, cash flow item.

Cash Flow Analysis (in Transaction Currency)

Figure 6. For any specified period, shows incoming and outgoing cash flows by cash flow item for each cash and bank account in the currency of accounts. The data can be filtered by entity, account, cash flow item.

Cheque Analysis

Figure 7. This report is available if the Cheque Accounting option is selected on the Administration > Settings > Money form. The report shows the issued cheques and how they affected balances of bank/cash accounts and received cheques in all currencies.

Loans Issued 

Figure 8. This report is available if the Enable Long-Term Credits and Loans option is selected on the Administration > Settings > General Settings form. The report shows how the balances of issued loans changed over specified time interval that includes one or more financial periods. You can view the amounts that were issued to borrowers, repaid amounts of principal, and accrued and paid interest amounts in the accounting currency. The column with fees may be hidden if fees are not applicable. The data can be filtered by entity, borrower, and/ or agreement and grouped by month, borrower, agreement. 

Loans Issued (Multi-Currency)

Figure 9. This report is available if the Enable Long-Term Credits and Loans option is selected on the Administration > Settings > General Settings form. The report shows how the balances of issued loans changed over specified time interval that includes one or more financial periods. You can view the amounts that were issued to borrowers, repaid amounts of principal, and accrued and paid interest amounts. Each amount is shown in the loan currency. The column with fees may be hidden if fees are not applicable. The data can be filtered by entity, borrower, and/ or agreement and grouped by month, borrower, agreement. 

Loans Received 

Figure 10. This report is available if the Enable Long-Term Credits and Loans option is selected on the Administration > Settings > General Settings form. The report shows how the balances of received loans changed over specified time interval that includes one or more financial periods. You can view the amounts that were received from lenders, repaid amounts of principal, and accrued and paid interest amounts in the accounting currency. The column with fees may be hidden if fees are not applicable. The data can be filtered by entity, lender, and/ or agreement and grouped by month, lender, agreement. 

Loans Received (Multi-Currency)

Figure 11. This report is available if the Enable Long-Term Credits and Loans option is selected on the Administration > Settings > General Settings form. The report shows how the balances of received loans changed over specified time interval that includes one or more financial periods. You can view the amounts that were received from lenders, repaid amounts of principal, and accrued and paid interest amounts. Each amount is shown in the loan currency. The column with fees may be hidden if fees are not applicable. The data can be filtered by entity, lender, and/ or agreement and grouped by month, lender, agreement. 

Payment Calendar

Figure 12. As an interactive report, it shows you the automatically generated cash flow forecast versus actual documents for the specified period and allows you to add certain documents for more correct cash balances.

Plan/Fact Analysis of Cash Documents

Figure 13. The report shows the projected payments and receipts versus payments and receipts actually occurred in the selected period.

Repayment of Loans Issued (Planned Vs Actual)

Figure 14. This report is available if the Enable Long-Term Credits and Loans option is selected on the Administration > Settings > General Settings form. For the selected range of financial periods, this report shows the amortization schedules for all open loans issued by the entity. You can view the actual amounts (in the loan currency) of principal, interest paid by borrowers versus planned repayment amounts. You can filter the data by entity, borrower, or loan agreement and group the data by borrower, loan agreement, or day, month, year.

Repayment of Loans Received (Planned Vs Actual)

Figure 15. This report is available if the Enable Long-Term Credits and Loans option is selected on the Administration > Settings > General Settings form. For the selected range of financial periods, the report shows the amortization schedules for all open loans received by the entity. You can view the actual amounts (in the loan currency) of principal, interest paid to lenders versus planned amounts. You can filter the data by entity, lender, or loan agreement and group the data by lender, loan agreement, or day, month, year.

Schedule of Payments to Suppliers Based on Payment Terms)

Figure 16. For the selected type of interval (Day, Week, or Month), the report shows the supplier documents with total amounts and amounts due in specific intervals. Also shows the documents that are overdue on the report date.

Statement of Cash Assets by Cash Flow Items (in Accounting Currency)

Figure 17. The report shows how the bank/cash account balances calculated in the accounting currency change by cash flow item during the specified period. You can filter the data by entity, supplier company, contract, or payment terms and group the data by document or payment terms.

Statement of Cash Assets by Cash Flow Items (in Transaction Currency)

Figure 18. The report shows how the bank/cash account balances change by cash flow item during the specified period. The balances are shown in their account currencies.

Statement of Cash Assets by Document

Figure 19. The report shows the changes in cash balances by document.

Statement of Employee Business Expenses (in Accounting Currency)

Figure 20. The report shows how the balances of the employee business expenses changed during the selected period with advances issued to employees and expense reports received from employees. The opening and closing balances are shown in the accounting currency.

Statement of Employee Business Expenses (in Transaction Currency)

Figure 21. The report shows how the balances of the employee business expenses changed during the selected period with advances issued to employees and expense reports received from employees. The opening and closing balances are shown in the currencies of operations and in the accounting currency.

Unmatched Bank Documents

Figure 22. This report is available if the Bank Statement Reconciliations option is selected on the Administration > Settings > Money form. The report lists all the bank documents with the Matched and Partly Matched statuses that were created and posted during the specified period to bank accounts for which the Reconcile Bank Statements option is selected in their master records. You can filter the data by entity, bank account, currency, and status.

Figure 1. Balances of Employee Business Expenses

Figure 2.  Bank Reconciliation Analysis

Figure 3. Cash Flow Statement


Figure 4. Cash Asset Balances

Figure 5. Cash Flow Analysis (in Accounting Currency)

Figure 6. Cash Flow Analysis (In Transaction Currency)

Figure 7. Cheque Analysis

Figure 8. Loans Issued

Figure 9. Loans Issued (Multi-Currency)

Figure 10. Loans Received

Figure 11. Loans Received (Multi-Currency)

Figure 12. Payment Calendar

Figure 13. Plan/Fact Analysis of Cash Documents

Figure 14. Repayment of Loans Issued (Planned Vs Actual)

Figure 15. Repayment of Loans Received (Planned Vs Actual)

Figure 16. Schedule of Payments to Suppliers based on Payment Terms

Figure 17. Statement of Cash Assets by Cash Flow Item (in Accounting Currency)

Figure 18. Statement of Cash Assets by Cash Flow Item (in Transaction Currency)



Figure 19. Statement of Cash Assets by Document


Figure 20. Statement of Employee Business Expenses (in Accounting Currency)

Figure 21. Statement of Employee Business Expenses (in Transaction Currency)

Figure 22. Unmatched Bank Documents

  • No labels