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 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. 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 8. 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 9. 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 10. 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 11. 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 12. 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 13. 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 14. 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 15. 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 16. The report shows the changes in cash balances by document. |
Statement of Employee Business Expenses (in Accounting Currency) | Figure 17. 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 18. 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 Received
Figure 9. Payment Calendar
Figure 10. Plan/Fact Analysis of Cash Documents
Figure 11. Repayment of Loans Issued (Planned Vs Actual)
Figure 12. Repayment of Loans Received (Planned Vs Actual)
Figure 13. Schedule of Payments to Suppliers based on Payment Terms
Figure 14. Statement of Cash Assets by Cash Flow Item (in Accounting Currency)
Figure 15. Statement of Cash Assets by Cash Flow Item (in Transaction Currency)
Figure 16. Statement of Cash Assets by Document
Figure 17. Statement of Employee Business Expenses (in Accounting Currency)
Figure 18. Statement of Employee Business Expenses (in Transaction Currency)