Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

13 shows

Report

Description

Cash Flow StatementBalances 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 in the Accounting module. Shows 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 masterrecords, 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 Assets Asset Balances

Figure 24. 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 in Accounting Currency)

Figure 35. For any specified period, the report 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 46. For any specified period, the report 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 5. The report shows 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 612. As an interactive report, this 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 for of Cash Documents

Figure 713. The report shows 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 in Accounting Currency)

Figure 817. The report shows 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 918.The  The report shows shows how the bank/cash account balances change by cash flow item during the specified period (Figure 9). The balances are shown in their account currencies.

Statement of Cash Assets by Document

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

Balance of Employee Business Expenses

Figure 11. The 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.

Statement of Employee Business Expenses (in Accounting Currency)

Figure 1220. The report shows 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

...

Image Removed

 

Figure 2. Cash Assets Balances

Image Removed 

...

. Balances of Employee Business Expenses

Image Added

Figure 2.  Bank Reconciliation Analysis

Image Added

Figure 3. Cash Flow Statement


Image Added

Figure 4. Cash Asset Balances

Image Added

Figure 5. Cash Flow Analysis (in Accounting Currency)

Image RemovedImage Added

Figure

...

6.

...

Cash Flow Analysis (In

...

Transaction Currency)

...

Image Added

Figure

...

7.

...

Image Removed

...

Image Removed

Figure 7. Plan/Fact Analysis for Cash Documents

Image Removed

...

Cheque Analysis

Image Added

Figure 8. Loans Issued

Image Added

Figure 9. Loans Issued (Multi-Currency)

Image Added

Figure 10. Loans Received

Image Added

Figure 11. Loans Received (Multi-Currency)

Image Added

Figure 12. Payment Calendar

Image Added

Figure 13. Plan/Fact Analysis of Cash Documents

Image Added

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

Image Added

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

Image Added

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

Image Added

Figure 17. Statement of Cash Assets by Cash Flow

...

Item (

...

in Accounting Currency)

...

Image Added

Figure

...

18. Statement of Cash Assets by Cash Flow

...

Item (

...

in Transaction Currency)

...

Image Added

Figure

...

19. Statement of Cash Assets by

...

Document


Image RemovedImage Added

Figure

...

20.

...

Statement of Employee Business

...

Image Removed 

...

Expenses (in Accounting Currency)

Image RemovedImage Added

Figure

...

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

...

Image Added

Figure 22. Unmatched Bank Documents

Image Added