Petty Cash Ledger Template Excel

The objective of organizations is to quickly present the final accounts and this is possible with a series of processes and availability of financial sheets like trial balance and profit and loss statement. With cash ledger template, your trial balance can be prepared quickly and in approximately half time making your accounting process simple and quick.

Do you know recording every single money related transaction is possible with a cash ledger template? Work that your bookkeeper does typically have mistakes, however when using the excel template.

  1. Saving ledger records in Excel format
  2. Compatible to any TEC (MAC-PC)
  3. Also, add in Google DOC or spreadsheet

your accounts and bookkeeping are error-free. On the off- chance, you may find calculating tax difficult, but this is no longer required!

Related Article: Purchase Ledger

Main Components of Cash Ledger Template

Get a breakdown of your costs and other expenses using this template? Now have a look at the key components of the template by going below on this page:


  1. Start by filling the company name in cell A1.
  2. Enter the name of your template in cell A2.
  3. Leave cash on hand blank as it is calculated with the function already entered in the template.

Particulars of the table

Do you see the merged cells? These cells are A3 and D3 with headings, debit/inward and credit/ outward.

  1. Now it is time to fill headings in the template.
  2. Add, date, particulars, amount in Rs. And again date, particulars, amount in Rs.
  3. Now start filling the date across any date and add the particulars as well.

Done with it add the amount in cell C5 for the debit transactions and enter the amount in cell F5 for the credit transactions

Total for the debit is calculated and shown in cell C21 with the formula, =SUM(C5:C20) and total for the credit is shown in cell F21with formula, =SUM(F5:F20).

Petty Cash Ledger Template

Submit Your Cash Ledger Inquiry

Now your cash ledger template is ready and it makes the preparation of trial balance a simple task. You can use it creating bank cash books, and other reconciliation statements. Another related template like cash flow forecasting, cash flow action plan, expense reporting, an income statement is ready for the management of your accounts.

Related Article: Bank Ledger

Loan Ledger Building Excel Template

This is the right platform to search loan ledger templates for managing building loan in excel tool. Debit and credit side are easier to manage through easy availability of these samples excel templates available here for downloading.

Printable ledger accounts are used to prepare trial balance and therefore provided a record of transactions that can, later on, be added in the balance sheet to show assets and liabilities of the company after year-end.

Due to easy availability of excel templates traditional ways of using paper sheets to manage accounts and recording transactions businesses have replaced these time consuming and expensive ways with the use of excel templates which are cost-effective options saving time and effort at the same time and making loan management easy.

Format Of Loan Ledger

  1. Account name
  2. Account number
  3. Date
  4. Description
  5. Debit
  6. Credit
  7. Balance
  8. Payable

These are the key variables focused when you are formulating ledger accounts. Building excel template is easier if you are well aware of the transaction date and the summing up the amount is easier by applying the formula available in excel templates. Loan payable (Rent Ledger) and receivable can also be observed from these templates.

Financial Document for Daily Transaction

If you are instantly recording transactions made in your business there are fewer chances of errors in these documents and therefore in other financial documents formulated by an accountant and viewed by shareholders and stakeholders of the company usually at year-end. Free general ledgers are now also available in printable form.

Building Ledger with Excel Template

Commonly t accounts are available in a similar format for companies and industries however key elements added are usually different and the amount incurred on each transaction is different.

Updating information on these ledger accounts is easy therefore Petty Cash Ledger Template is searched and downloaded by various users from here.

Leave a Reply

Your email address will not be published. Required fields are marked *