
User-defined Financial Statements, Trial Balance, General Ledger Report and more. Optional subaccounts for branch, division, product group, etc. No monthly closing of the general ledger required. FREE basic features or purchase full version. To have those values calculated automatically, you may need the Integrated Accounting System for Trading/Retail Business spreadsheet where this spreadsheet is part of it.BS1 General Ledger software tracks budget and actual financial data for financial statements, Trial Balance, General Ledger Report, GL Totals, GL History, and Charts. It is used to record financial transaction only. Spreadsheets that you download has no automatic financial reporting tool. Because all values will be placed in particular accounts to be pulled in income, cash flow, balance sheet and equity report. This double-entry system is used by people to ease their accounting and financial report. Basically, it is used to satisfy the equation Assets = Liabilities + Equity, in which each entry is recorded to maintain the relationship.
It usually stated in debit/credit status. It means every financial transaction must have equal and opposite effects in at least two different accounts. This template accommodates a double-entry system bookkeeping format. But, in Services type company, general journal will be used to record all transaction because it usually doesn't need special journal.
General journal, like its title, is allocated for all transactions outside Sales and Purchase transaction. Special journals are used in Trading/Retail business where Cash and Non Cash transaction are separated in both Purchase and Sales accounts. Both are having similar formats but different account allocation. There are General and Special Journal in this package. Accounting Journal Template for Excel is an Excel spreadsheet template to record your company sales, purchase and cash transactions with accounting double-entry bookkeeping format.