V. How to analyze

V. How to analyze

Through various reports, which is the greatest strength of whooing, you can accurately analyze the current status and flow of your assets. You can also use the basic menus on the left side menu, or if you don't have enough, take a look at the lab and various things to do.

Report common items

Most reports from whooing are organized in the format below. Knowing the common aspects of managing reports can help you use them faster and more usefully.

Report title

The most important part of the top left is the title of this report. Clicking on this report title automatically takes you to the settings area for this report in Preferences. There, you can set the basic inquiry period of the report.

Share the report

Top right of each report> Click Share button> Click Create Share Link

You can create a sharing link for the currently displayed report and period (including conditions). The creation of a sharing link alone does not make it public, and people who know the link can access it from the moment the user directly shares the link.

As the currently displayed data is fixed as soon as the sharing link is created, the data that is modified in the future is not automatically reflected.

The management page for the created shared link is not exposed in a separate navigation, and can be accessed by clicking Share> Manage Shared Documents in any report.

report scrap

The current report and period (including conditions) are scrapped. You can think of it as a function like a bookmark. By default, the current period is entered as a fixed value, but it can be scraped with a relative value (last 1 month). You can access the scraped report by pressing the button to the right of the scrap button of each report, or you can use the scrap button in the main navigation.

Report search condition

This is the area to adjust the period to be displayed and the conditions that can be set for each report.

Manual period

Depending on the characteristics of the report,'Year-Month' or'Year-Month-Day' is displayed. Using the keyboard and , you can adjust the period slightly from before or after, or you can use the date picker by clicking with the mouse. And if you click'~' between the date fields, the two periods are matched.

Is it a little more convenient to select a preset period

You can also specify the date directly on the left side of the query condition, but this process is more cumbersome than you think. In that case, you can search with one click using the preset period on the right. In the rightmost column, you can search for relative dates based on the present. To explain the symbol, indicates the current, the arrow indicates the direction of time, and the number indicates the number of months. In other words, the period indicated by 1←ㅇ means to search the past 1 month from the present.

Move before/after

When you approach the inquiry condition area with the mouse, the quick inquiry button at both ends is activated. Pressing the left searches the previous period as much as the currently searched period, and pressing the right searches the period after the current search period.

Report body toolbar

In the main text of the report, there is a small toolbar in the upper right corner for each meaningful block (chart or table) unit. Each button provides the following useful functions for that block.

View as popup

Pop up the area as a mini popup. When similar but different information is needed, pop-up fragments can be popped up in this way, positioned and compared while analyzing.

excel save

This is a function to save the data of the relevant area to Excel. Excel is saved as standard Excel 97, so compatibility is good.

print

A window to print the data of the area is displayed. Instead of printing as it is on the screen, it is converted to a form that fits the document and printed.

Transaction input, all data input

On this page, you can check the transaction input and entered transaction details directly below. While other reports aim to see and understand information, transaction input consists of the only active input function. The screen composition is as follows.

Useful functions above

At the top of the page, there are various useful functions for input.

Frequently entered transactions

You can use this feature to register and utilize when entering a specific transaction frequently. If you select this tab on the transaction input page and select a registered item, the settings are automatically applied to the transaction input form below. If there is any modification, click the'Edit' button on the top right, and you can edit/delete existing items, register new items, and change the order.

This function is provided for convenience and does not have to be used. When entering an item in the transaction input form, the previously entered items appear in the item suggestion list, so you can just use this function. Or, even if you use external input or automatic financial data input, you do not need to manage frequently used items.

Basically, the area is divided into two on each side. If you want to change the number of these areas, you can proceed to the configuration.

Monthly input transactions

If you repeatedly enter a specific transaction every month, you can register and use it here. If you select this tab on the transaction input page and select a registered item, the settings are automatically applied to the transaction input form below. If there is any modification, click the'Edit' button in the upper right corner, and you can edit/delete existing items and register new items.

Unlike frequently entered transactions, the order is forcibly sorted in the order of the date to be entered. In addition, D-Day is additionally displayed for each item, how much is left for the target date where the date should be entered.

This function is provided for convenience and does not have to be used. If the monthly recurring amount is always constant, it is recommended to use the automatic split input function.

Classification in whooing follows the rules of Item> Item. Therefore, even if parentheses are added to items when registering monthly transactions to be managed, in reality, only items that meet the classification criteria are determined whether or not to be entered. Even if'Insurance (A)' and'Insurance (B)' are registered respectively, if there is a transaction of an item called'Insurance', it is recognized as input. Therefore, if it is completely different, it is recommended to separate it in the item hierarchy such as insurance_A and insurance_B.

open external input

Opens the external input window where external payment data can be automatically loaded and entered. For detailed external input, refer to External Input and Automatic Financial Data Input.

This external input can be called by pressing the shortcut o anywhere in whooing. For a full description of shortcuts, see Shortcuts, Speed ​​Up.

open awesomebox

AwesomeBox does not have to explicitly fill in individual information as in the transaction entry form. In addition, the order of each component is also a magical function that takes care of inputting it as you think. For more information, see Awesome Box, Easy Input by Command.

Transaction input form

This transaction input form can be called from anywhere in whooing by pressing the shortcut i. For a full description of shortcuts, see Shortcuts, Speed ​​Up.

This is the most central area on the transaction entry page. The actual transaction is entered here. Entering a transaction goes beyond simply filling out the information in the form and sending it. Transaction input is the act of setting an item/client for a transaction and matching any left/right item. In other words, it records changes in money and sorts them at the same time. For a general conceptual explanation of each component of this form (date, item, etc.), see IV. See how to enter.

The transaction input form is designed in the direction of filling in the items/businesses from the date on the left and the information on the right. If you enter from the left, the amount/left/right is automatically placed for the same input as the moment you enter the item/customer. In addition, since it supports keyboard input smoothly, you can quickly input by combining the tab key with the and keys.

You can turn off the function that automatically places the amount/left/right upon completion of item/customer input. Try tapping the chain icon just above the item entry box.

When entering left/right items, just enter consonants to see a list of suggested items. When a list of suggestions appears, you can quickly access them using the and keys on the keyboard. As the number of items increases, it is more convenient to select through this function.

Recent entries

The transaction entered in the transaction input form above is sent to the server, and when a response from the server stating that the normal entry is approved, it is added to the top right here. This list is fixed so that it is unconditionally displayed in the order of last entry. Regardless of the date of the transaction, it is displayed in the order entered, so you can check the recently entered information and prevent accidental duplicate entry, or enter only transactions since the last entry time.

At the top right of this list is a trash bin feature that allows you to recover accidentally deleted transactions. Recycle Bin only stores transactions deleted within the last 1 week.

Change the order in transaction input

To view the transaction details in the chronological order we generally think of, please use the Transaction History page. Separately, the order of transactions on the same date can be changed anywhere the transaction is displayed. You can randomly specify the order of each transaction on the same date by clicking'Change Order' on the right side of the transaction details.

Even if it is adjusted on the transaction input page, it is not reflected on the screen due to the basic sorting rule.

Transaction history, the basis of the report

Whooing's main report is the transaction history. In this report, all transaction details are basically displayed in chronological order, and you can edit or delete each transaction. However, transaction history provides a ton of additional functions for basic transaction inquiry and history. There are a lot of lovely reports, but no one will be as lovely as your transaction history.

Various search conditions

Various functions are arranged in the inquiry form in the transaction history.

-If you press ~ between the start date and the end date, the start date is copied to the end date. -If you click'Separate' in the item field, you can specify the left and right items separately. -The item field searches for matching items by default. However, you can use * (universal symbol) to replace all characters, such as *search word and *search word*. -When searching for parentheses, enter a search term enclosed in parentheses, such as'(search term)' in the item field. -If you click Detailed Display, the memo field and the amount range field are activated.

Related reports

Depending on the search conditions, necessary hidden detailed reports are displayed. For example, if you search for an asset item, a report is activated that shows the change in the balance of the item and the flow of funds based on that item. When searching the total cost or profit, a chart graph of each detailed item is displayed, and when searching for an item, the total of the items in the item is displayed.

Multi-selection tool

Management in the transaction history can be more convenient. If you're connected from a computer, try clicking and dragging an empty space in the transaction. You can select up to 60 items at once, and if you click the edit button at the bottom in that state, you can make bulk changes to specific fields (date and item, etc.) of the transaction. You can also select similarly and'reenter' or'delete' at the bottom.

Total within period

The total sum of each transaction is displayed for the searched period. In the case of an unconditional full inquiry or an asset or liability inquiry, the accumulated amount from the start of the household account book to the searched period is displayed. It is a concept similar to the balance of a deposit and withdrawal passbook. On the other hand, if you are looking at the cost or revenue side, it displays the sum of the start and end dates.

The total within the period may not be displayed under certain conditions. This includes searching for items for which no item is specified.

Cost income, money flow

Whooing is doubles bookkeeping, so you can manage all the different forms and flows of money. Nevertheless, the biggest factors we can feel are outgoing costs and incoming revenue. Therefore, managing costs and profits in doubles bookkeeping whooing is very frequently used and useful.

As explained on the item page, if you have categorized the cost and revenue items according to the purpose you want to identify in the first place, there is nothing to deal with. As you can see, you can also look up the period and see the amount by item. However, there are some more advanced ways to use it. Basically, it is explained based on cost only.

floating-fixed

For the cost and revenue items, it is mandatory to select whether it is a floating item or a fixed item (unless otherwise set by the user, it is set to the default, floating item). And in the report, the sum of the floating items and the sum of fixed items are separately displayed at the bottom of the table.

Use of groups

If you created groups in preferences, this report displays the sum of the items each group contains. For more information on groups, see Adding and Editing Items.

user calculation

You can create a selective calculation formula at the bottom of the report, just as you can grasp the status of asset, liabilities and money at a glance. For settings and utilization, please refer to user calculations, enriching report information.

Assets, liabilities and money status identification

The biggest advantage of doubles bookkeeping is the report on these assets and liabilities. It is the second most used report in whooing after the report on cost, income, and money flow. It can be said to be an important report.

Use of groups

If you created groups in preferences, this report displays the sum of the items that each group contains. For more information on groups, see Adding and Editing Items.

user calculation

As with cost income and money flow, you can selectively create calculations at the bottom of the report. For settings and utilization, please refer to user calculations, enriching report information.

Budget, the king of the end of meticulous management

A budget is more than just controlling yourself as a plan for money, it also allows you to predict future assets. Manage and achieve goals with whooing's robust budgeting capabilities.

revenue budget

Usually when you think of a budget, you think of a budget for the cost of spending money. But if your profits are unpredictable, you won't be able to raise money easily, no matter how much control you have. In whooing, revenue is also managed as a budget. You may be thinking,'If you manage your budget, you can't earn more. What are you doing?' However, if you think about it, it is not easy to reduce the cost even if you have a budget. Difficulty keeping costs, profits, or budgets is similar. However, if you manage and keep both of these, the future can be predicted.

long-term goal

In addition to the revenue budget, you can predict your capital status in the next year or 10 years. You can make assumptions such as'how much you earn now, how much you spend, and when you go like this, how much can you save in 10 years' or'how much you have to save in 5 years, how much is your profit and how much you have to reduce the cost to' . And by recording them numerically, you can set a budget for revenue and expenses, and stick to them to achieve your goals.

The set target is indicated by a dotted line in the total asset change report. After setting, you can check whether the goal is achieved by looking at the difference between this line and capital. If you want to turn off these long-term goals, see the Budget section of the Preferences page.

automatic setting

After setting long-term goals, you can set monthly/item budgets right from the actual report page. It is equivalent to budget setting in ordinary household account books. In whooing, there are options to set automatically based on existing records to make it easier to set each item. Click'Budget (Edit)' in the area where each month is displayed on the budget page, and then click'Auto Set' at the top right.

Cash flow statement, current asset management

Assets can be categorized by various attributes, but liquidity is of particular importance. This is because it is possible to extinguish an emergency fire through liquid assets without external assistance in coping with an emergency situation. If these current assets aren't enough, you may have to sell fixed assets at a bargain price or bring in high-interest liabilities when you need to rush. In addition, if that time is delayed, you may have to pay a high price, such as insolvency.

To prevent this situation, whooing provides the ability to set liquid cash on the category of the asset. If you set the asset category to liquid cash, you can easily see the status of the related items in this report.

You can also create a group of liquid assets and see the current status in asset liabilities. However, if you set it as liquid cash and use the cash flow statement report, more information will be provided.

In this report, you can see a summary of the total amount of cash remaining before the period viewed, as well as the cash increase or decrease in the period and the final cash situation. And just below is a chart of how each cash was spent during the inquiry period.

A chart of changes in the cash balance will be added within the searched period in the future.

Funds increase or decrease

Useful without worrying about credit cards and debts

Credit cards are easy to use, but they are one of those very difficult to manage. 'I get a monthly usage report. What's the problem?' You can also do it. But is it really? Whether you have enough balance in your payment account on the usage period, payment date, and settlement date so that it will not go over to revolving, the monthly installment amount, and how long will it be charged, what are the charges for all the credit cards you use. A simple monthly report sent by a credit card company is not enough.

How to set up a credit card

On the Preferences page, go to Debt. After clicking Register, set the type to'Credit Card' in the item form. Just below the link to set up additional information, click this to call up the credit card form as well. You can connect the usage period and payment bank, and set a target amount.

Here, the payment bank only matches and expresses the information, and does not automatically enter the settlement transaction on the payment date. Since there are actually so many variables, we avoid entering distorted information automatically.

After setting, each time you pay with a credit card, you will be prompted for a credit card payment transaction by selecting the corresponding'cost item' on the left and'corresponding credit card+' on the right. Then, in case of prepayment or settlement, you can enter'Applicable credit card-' on the left and'Settlement account-' on the right.

The amount reduced due to settlement, etc. does not affect the credit card report. This is because the credit card report is to verify the amount charged. For billing discounts, use negative amounts to select the same cost item on the left and credit card on the right.

Basic credit card settings

If you're already using a credit card at the beginning of whooing, setup is a bit difficult. You have to deal with the following things.

-At the beginning, the estimated billing amount in real time is investigated and registered as the basic balance. -Investigate the remaining installments at the beginning, and register the remaining installments by entering monthly installments (Description of monthly installments note)

And even if you register and start with the basic balance of your credit card, some of the above may be misaligned. This is because some things that have been paid but have not yet been approved by the credit card company are applied after a day or two.

Periodic income 1

You can see the fluctuations in revenue, costs, and net income over time.

term income 2

Periodic profit or loss 1 is a chart of overall profit and cost, while period profit and loss 2 is a more detailed graph by group or item.

asset change

Asset changes can easily identify changes in assets/liabilities/capital within the period. If you have set a long-term target for your budget, the net worth target for each month is added as a dotted line to this chart. It is easy to see if it is increasing as planned by comparing the yellow net asset change with the gray dot line.