Access ALL our Excel Templates for only $9/month

Description

This Accounting Book worksheet is intended to allow you to record all entries and exits made by a company. It automatically generates the balance sheet, cash flow statement, statement of income and balance sheet for the year analyzed.

Checkout the Features of This Spreadsheet

Chart of Accounts
Record all assets, liabilities, shareholders' equity, income and expenses accounts in accordance with their accounting code.
Registration of Accounting Entries
Define the debit and credit accounts linked to each of the possible accounting entries to be made in the analyzed company.
Control of Accounting Postings
Take control of all accounting entries that occurred monthly for each of the months of the year under review. This will be the basis for automatic creation of the balance sheet, DFC, DRE and balance sheet.
Balance sheet
The balance sheet is an accounting statement that gathers all the accounts in motion in the company and serves to verify their respective balances debtors and creditors.
Cash Flow Statement (Cash Basis)
The Cash Flow Statement (DFC) indicates which were the inflows and outflows of cash (cash accounts) in the cash for the period and the result of the financial year.
Accrual Basis Report
This report presents in a summarized vertical form the result calculated in relation to the series of operations carried out during the year.
Balance Sheet
The Balance Sheet (BP) is the main existing financial statement (mandatory by law). It shows how the company's equity is actually reflecting its financial position at any given time (at the end of the year or at any predetermined date).
Balance Sheet ready for printing
In addition to the managerial view, the accounting journal worksheet automatically creates a balance sheet report for printing.
Summary of Accounting Entries
See in a control panel exactly what were the balances of assets, liabilities, shareholders' equity, incomes, expenses and final balance.
average rating 4.5 out of 5
Based on 4 reviews
  • 5 Stars
    2 Reviews
  • 4 Stars
    2 Reviews
  • 3 Stars
    0 Reviews
  • 2 Stars
    0 Reviews
  • 1 Star
    0 Reviews
100% of reviewers would recommend this product to a friend
4 Reviews
Reviewed by WARLLAN CEZAR R., from Brazil
Verified Buyer
I recommend this product
Rated 5 out of 5
Review posted

5 Stars

Planilha Livro Caixa em Excel 4.0

Loading...
Was this helpful?
Reviewed by LUIS SERGIO CORREA C., from Brazil
Verified Buyer
I recommend this product
Rated 4 out of 5
Review posted

Livro caixa

Gostei bastante, mas poderia ter o acumulado de 3 anos e não ficar dando mensagem que foi validada com sucesso toda vez q abre ela.

Loading...
Was this helpful?
Reviewed by Antônio Carlos Carvalho J., from Brazil
Verified Buyer
I recommend this product
Rated 4 out of 5
Review posted

Feedback - Planilha Caixa

Planilha bastante dinâmica e de fácil operacionalização.

Loading...
Was this helpful?
Reviewed by paulo roberto a.
I recommend this product
Rated 5 out of 5
Review posted

AVALIAÇÃO

Achei a planilha ótima. Fácil de operar. Só estou tendo um probleminha, quando quero inserir uma linha e acrescentar um valor na linha inserida no meio da planilha, os valores não se ajustam automaticamente. Poderia me ajudar? Quanto ao resto, gostei muito!

Loading...
Was this helpful?

Product Specs:

  • License to 3 Computers
  • 100% Editable File
  • Immediate Access
  • Works on MAC and PC
  • All Excel Versions
  • Premium Support
  • Over 30.000 satisfied customers