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.

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

1

2. The report

is available in the Accounting module. Shows

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

2

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

in Accounting Currency)

Figure

3

4. 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 (see Figure 4). The data can be filtered by entity, account, cash flow item.

Cash Flow Analysis (in Transaction Currency)

Figure

4

5. 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

6.

The

The report

shows

shows the issued cheques and how they affected balances of bank/cash accounts and received cheques in all currencies.

Payment Calendar

Figure

6

7. 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

7

8. 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 9. 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 10. 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 11. 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

8

12. 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

9

13. 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

10

14. 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

12

15. 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

13

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

Figure 1.

...

Image Removed

 

Figure 2. Cash Assets Balances

Image Removed 

...

Balances of Employee Business Expenses

Image Added

Figure 2. Cash Flow Statement


Image Added

Figure 3. Cash Asset Balances

Image Added

Figure 4. Cash Flow Analysis (in Accounting Currency)

Image RemovedImage Added

Figure

...

5.

...

Cash Flow Analysis (In

...

Transaction Currency)

...

Image Added

Figure

...

6.

...

Cheque Analysis

Image RemovedImage Added

Figure

...

7.

...

Payment Calendar

...

Image Added

Figure

...

8.

...

Plan/Fact Analysis

...

Image Removed

...

of Cash Documents

Image Added

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

Image Added

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

Image Added

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

Image Added

Figure 12. Statement of Cash Assets by Cash Flow

...

Item (

...

in Accounting Currency)

...

Image Added

Figure

...

13. Statement of Cash Assets by Cash Flow

...

Item (

...

in Transaction Currency)

...

Image Added

Figure

...

14. Statement of Cash Assets by

...

Document


Image RemovedImage Added

Figure

...

15.

...

Statement of Employee Business

...

Image Removed 

...

Expenses (in Accounting Currency)

Image RemovedImage Added

Figure

...

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

...

Image Added