You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 21 Next »

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.

Cash Flow Statement

Figure 2. 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 3. 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 4. 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 5. 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 6. The report shows the issued cheques and how they affected balances of bank/cash accounts and received cheques in all currencies.

Loans Issued 

Figure 7. 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 8. 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 9. 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 10. 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 11. 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 12. 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 13. 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 14. 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 15. 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 16. 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 17. 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 18. The report shows the changes in cash balances by document.

Statement of Employee Business Expenses (in Accounting Currency)

Figure 19. 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 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 currencies of operations and in the accounting currency.

Figure 1. Balances of Employee Business Expenses

Figure 2. Cash Flow Statement


Figure 3. Cash Asset Balances

Figure 4. Cash Flow Analysis (in Accounting Currency)

Figure 5. Cash Flow Analysis (In Transaction Currency)

Figure 6. Cheque Analysis

Figure 7. Loans Issued

Figure 8. Loans Issued (Multi-Currency)

Figure 9. Loans Received

Figure 10. Loans Received (Multi-Currency)

Figure 11. Payment Calendar


Figure 12. Plan/Fact Analysis of Cash Documents

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

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

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

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

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



Figure 18. Statement of Cash Assets by Document


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

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

  • No labels