Cash Flow in Tabular View

Tabular View

The Tabular View displays a company's actual and forecasted cash flow transactions in a simple tabular format. You can see the company's historical cash balance for the past twelve months and predict the next 12 months.

Understanding the Basic Features

Period

Daily shows the actual and forecasted data for every single day along with the opening and closing balance. With the current date in focus, you can scroll to the previous as well as the next days.

Weekly shows the actual and forecasted data with the current week in focus and the option to scroll to the previous or next week. The default week format will be from Monday to Sunday.

Monthly shows 12 months of data at a time. It includes the actuals of the previous 12 months from the current date and the next 12 months' calculations based on the downloaded data from the accounting software.

Range

Select the past and forecasted days/weeks/months from the drop-down right above the table, and it will show data for those selected days/weeks/months on the cash flow graph.

Scroll

You can scroll to previous and subsequent days' data by clicking the arrows on the top corners of the table.

Go to Date

You can view calendar information by day, by month, and by year. To change between different views, click the Calendar icon buttons in the top-left corner of your table. Select the date, month, or year to see the data.

 

Transactions

You will see three types of transactions both in the table and the graph.

1. Actuals show the accounting software data from the past 12 months and the coming 12 months from the date last synced.
2. System Forecast displays cash position for the next 360 days as per the last synced data from the connected accounting software.
3. User Forecast displays the figures you have added manually through various options available in a tabular view.

Today's Balance

The data before the grey dotted line is the actual transactions from the accounting software, while the one on the right side is the predicted cash flow.

Please note Actual transactions can neither be deleted nor modified.

Quick Action Buttons

You will see three dots right next to Cash In and Cash Out. Click to Add a New Transaction, View Excluded Transactions, Manage Chart of Accounts,  Manage Contacts.

Expand & Collapse the Transactional Data

By default, the transactional data is displayed in the collapsed view. It will list only the COA heads with respective total only and no transactions.

Click the arrow to view transaction details of customers/vendors as per respective COA groups.

Understanding the table                       

The left side of the table categorizes the company's transactional data.

• Opening Balance is the amount, negative or positive, in your business account at the start of the accounting period.
• Cash In, which further expands to Invoice, Income, and Other, is further drilled down to the Chart of Accounts and Customers.
• Cash Out, which further expands to Bills, Expenses, and Other, is further drilled down to the Chart of Accounts and Vendors.
• Closing Balance is the amount, negative or positive, remaining in your business account at the end of an accounting period.

The multi-level view

The data is displayed in a collapsed view by default for every head with the COA group. You can drill down to get the details of a transaction.

Level 1

• Level 1 displays the total of Cash Flow Heads.

Level 2

• Click a Cash Flow head, and it will display the Chart of Accounts under that head.

Level 3

• Click the Chart of Account, and it will display the contacts for that particular category.

Not Specified Transactions

You will see some transactions as Not Specified in forecasts. There could be two reasons for Not Specified Transactions.

• If there's a transaction entered without a contact name in the connected accounting software, it will show Not Specified in Predict.
• If there are multiple irregular transactions under a particular chart of account in your accounting software, they will be collaborated as Not Specified in Predict.

Add New Transaction

You can do forecasting by adding transactions through Cash-In or Cash-Out to assess the impact directly into the Tabular Cash Flow View.

Visit Add New Transaction for more details.