Skip to content
BookkeepKit

Journal Entry Template

Write an adjusting or correcting entry with as many lines as you need. Debits and credits are totaled and checked, and the entry downloads in the formats QuickBooks imports.

Entry

Lines

Journal entry lines
AccountDescriptionName (optional)DebitCreditRemove
  • A journal entry needs at least two lines.

How it works

  1. 1

    Number and date it

    Give the entry a number, a date and a memo that explains why it's being made.

  2. 2

    Add the lines

    One account per line, with a debit or a credit. The template flags lines with both, or with no account.

  3. 3

    Download

    Excel or PDF for the file, a CSV for QuickBooks Online's journal import, or an IIF file for QuickBooks Desktop.

Anatomy of a journal entry

A journal entry records one event in at least two accounts. The total of the debit lines always equals the total of the credit lines; that's what keeps the books in balance. A good entry also has a date that falls in the right period and a memo someone else can understand in a year.

Common entries for small businesses

  • Monthly depreciation: debit Depreciation Expense, credit Accumulated Depreciation.
  • Prepaid insurance used up: debit Insurance Expense, credit Prepaid Expenses.
  • Accrued expense: debit the expense, credit Accrued Liabilities, then reverse it when the bill arrives.
  • Outside payroll: debit Wages and Payroll Tax Expense, credit Checking for the net pay and Payroll Liabilities for taxes withheld.
  • Reclassification: debit the correct account, credit the one it was posted to by mistake.

Before importing

Make sure the entry balances (the summary shows the difference until it does) and that every account name exists in the company file. Imports fail on unknown accounts rather than creating them.

Frequently asked questions

When do I need a journal entry?

For anything that isn't a sale, bill, payment or bank transaction: depreciation, accruals, prepaid expense adjustments, payroll from an outside provider, reclassifying a miscoded expense, or correcting an opening balance.

Which side is debit?

Debits increase assets and expenses and decrease liabilities, equity and income. Credits do the opposite. Recording depreciation, for example, debits Depreciation Expense and credits Accumulated Depreciation.

How do I import the CSV into QuickBooks Online?

Go to Settings > Import data > Journal entries, upload the CSV and confirm the mapping. Account names must match your chart of accounts exactly, including sub-account paths such as Utilities:Electric.

How do I import the IIF into QuickBooks Desktop?

Back up the company file, then use File > Utilities > Import > IIF Files. Debits are written as positive amounts and credits as negative, which is what Desktop expects for a general journal transaction.

What's the Name column for?

Lines that touch accounts receivable or payable need a customer or vendor in QuickBooks. Leave it empty for other lines.