Language and currency menu colors and fonts changing the logo adding on deleting tabs and customer support the main new features of the spreadsheet.
Are the import of entries into the spreadsheet allowing entries to be imported from a system or from some other version of this worksheet it analyzes cost centers Banks customers.
And suppliers entrances between bank accounts in entries we have a new form that makes entering new data much easier being able to make single entries and also install.
Installments into the last month of the year automatically when filling out the form starting with chart of accounts in the first accounts tab fill in the account.
In sub-accounts we have a list with the account group previously registered which when selected automatically shows the type of revenue or expense next we register the subaccount that.
Belongs to that group and type in 1.3 cost centers we register the cost centers moving on to Banks we enter the name of the bank starting balance and payment.
Methods and customers suppliers we can register them by inserting name telephone email and observation transfers allows us to break down.
Transfers by informing the date Bank of origin and Target Bank as previously registered and value of the transfer in the second large time entries we have the months of the year at the top.
For each month is possible by clicking on the enter new revenue or expense posting button to fill in the form with all the options that we were informed in the chart of accounts tab.
Veja Também:
- Planilha de Orçamento Familiar
- Método ÚNICO e SIMPLES que Eu Uso para CRIAR Negócios de Sucesso na Internet 100% do Zero.
- Planilha Excel de Fluxo de Caixa Grátis.
In this case for example inside - Luz Prime
Launch type we select unique or installments and the payment method as previously registered we can select plan of accounts Bank cost center.Customer supplier then we can fill in the missing information by clicking on add the data is automatically inserted into the.
Worksheet after that we select clear and we can do as many more entries as we want and financial planning on the goals tab we establish the revenue and expense.
Goals and compare them with what was accomplished per month generating the result goal and the realized results analysis shows us the total revenue expenditure profit or loss and.
Profitability by goal and by accomplished as we establish the maximum margin of error we can have both positive and negative alerts.
Moving on to General reports in cash flow we can visualize everything that was previously filled in organized by General banks cost center and customer or supplier.
Foreign statements we can see also organized by General banks cost center and customer supplier and detail accounts the reports are both.
Both on a cash basis that comes from the payment date on an actual basis which analyzes the posting date moving on to print we can visualize cash flow Revenue statement and cost center.
Reports with charts and also the goals accounts payable and receivable all organized for printing and the fifth step specific reports we also have the result of the day and open.
Values
All organized by day with Revenue expenditure and result of the day upon selecting the month we also have the accounts payable and.Receivable that considers the three entry dates release due date and payment we also have reports by Banks.
And by forms of payment finally in dashboards we have the graphical representation of of all the data entered throughout the worksheet monthly analysis allows us to visualize.
The revenue expenditure profit and loss and profitability when searching for the desired month with charts below them annual review shows us the ears profit loss total with analysis and graphs of.
Revenue and expenses and accounts receivable accounts payable by month in account analysis we select an account group and we can view account amounts for the year.
Representativeness split by account groups and the top five sub-accounts and the monthly account evolution specific analysis allows us to select the cost center does having a chart with.
It the bank we can also select customer and the payment method or with monthly charts finalizing the worksheet in custom to review We select the month and the cost.
Center and we can visualize its revenues expenditure profit loss profitabilities and also some charts below such as a revenue expense profit lasts for the year.
Postar um comentário