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

Compare with Current View Page History

« Previous Version 20 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 (Multi-Currency)

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 (Multi-Currency)

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 (Multi-Currency)


Figure 8. Loans Received (Multi-Currency)

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)

  • No labels