Bookkeeping Templates

Bookkeeping templates consist of the ticket, trial balance, and statement of financial condition or balance sheet templates. Moreover, bookkeeping templates include income and expense, bank reconciliation, and budget templates. In this article, I wrote a brief meaning of each template.

Here are sample Bookkeeping Templates

Ticket Template

A ticket template is one of the bookkeeping templates. A ticket is a label you make or create (accounting system) for a retail product or service. It serves as a journal entry of a transaction. The ticket could be a sales ticket, sales refund ticket, payments ticket, and debit or credit memo ticket. It could also be an expensive ticket, purchase ticket, payroll ticket etcetera. To illustrate, a journal ticket is compared to an airline ticket. An airline ticket is a piece of paper or a small card. It gives the holder a certain right to enter a place or travel by public transport.

While a journal ticket is a piece of paper with attached supporting documents like receipts. It gives the holder validation and permission to enter the transactions into the record book. To enter a transaction to the book is by ticket entry. A ticket entry – is made only when a transaction is validated. A transaction is validated when there’s proof of transaction made. Proof of transaction means evidence that identifies the supplier or seller. Moreover, the cost, the date of supply, and the goods or services supplied to purchase or buyer. It is also called the official receipt. Which is signed by the person accepting the money and gives the original copy to the person making the payment.

If you have questions or need customization of bookkeeping templates based on your company needs contact us

Trial Balance Template

The trial Balance template is another bookkeeping template. Trial balance template – used to bring all the amounts of debit entries and the credit entries into balance. After all the transactions for the day ticket entries are made it is posted to the trial balance. This is to trial the debit amount and credit amount if tally. Posting means transferring the details from ticket entry to the trial balance sheet. By posting the ticket entries to the trial balance, you can get the total amount per account. Posting all transactions in one worksheet makes it easy to identify errors and what is missing in the transactions. Furthermore, it gives an awareness of how much of a cost was taken or given away.

Statement of Financial Position Template

In addition Statement of financial position is also a bookkeeping template. From the trial balance, the amounts were then being carried to the statement of financial condition or balance sheet. The account names together with the total balances are presented to the balance sheet based on liquidity. Liquidity in accounting means the conversion of assets into cash. Balance sheet presentation can give an idea of which asset own will be converted to cash chronologically. Because assets are arranged based on how fast it can be converted to cash – the most liquid asset.

Statement of Income and Expense

The Statement of Income and Expense is another bookkeeping template. After the trial balance, the total amounts will be forwarded to the income and expense summary report. The arrangement is total income followed by total expenses then lastly the net effect difference. Net income or net loss is the difference of gross income versus total expenses. Gross income – The total income carried from the trial balance. Furthermore, it is the income before deducting the total expense, taxes, and other charges. To illustrate the net income, a fishing net is a good representation. When a fisherman lifts the fishing net, only the fishes that remain inside the net will be accounted for. Some fishes pass through the net and some manage back to the water. These fishes – considered catch but not counted. It is the same as net income, gross income is considered income but subject to deductions, tax, and other charges.

Bank Reconciliation Bookkeeping Templates

A Bank reconciliation templates are also one of the bookkeeping templates. Bank reconciliation templates – used to bring the two balances (book and bank) from a different source tally. To bring the bank balance and book balance tally is by reconciling items. Reconciling items – the difference between balances from two sources compared. There are two sets of reconciling items namely the book reconciling items and the bank reconciling items.

Book reconciling items:

1.) Notes collected by banks

2.) DAIF, DAUD, and Close account (bounced) checks

3.) PCHC maintenance fees and other services charges

4.) Company error

Bank reconciling items:

1. Deposit in transit

2. Outstanding checks

3. Bank error

See more about bank reconciliation

Budget vs Actual Bookkeeping Templates

This template is very important for the company to prosper. The budget template is a very helpful bookkeeping template. Budgeting control is the use of budgets in controlling operations. The budget report is to budget vs actual. Usually, bookkeepers gather the 5 years’ data of the company to measure the average income and expenses. Then presented for clarification to the management. Furthermore, suggestions, additions relative to the company plans, etcetera during the meeting. After that, the management will finalize the budget. Lastly, presented to the Board for approval. Finally, if the board agrees to all the proposed budget then it will be prepared and reported. Otherwise, revised. The revised budget presented as an amended budget at the next Board meeting. To develop a flexible budget, a company should identify fixed costs and variable costs. For the variable cost, the company should estimate the future income and expenses congruent to the company plans

To see more budget templates click here . If you have questions or need revisions and customization of bookkeeping templates contact us.