Skip to main content

Purchase Journal: Step-by-Step Guide

Updated today

Overview

The Purchase Journal in DizLog is a read-only accounting report that lists all purchase-related entries for a chosen period.

It sits under Financials → Books of Original Entry → Purchase Journal and is described in the app as part of the BIR-aligned ledgers and journals with export-ready totals.

The page shows each relevant account (for example, Unmapped Account, VAT Control) with:

  • an Opening Balance

  • all purchase transactions within the selected dates

  • a Closing Balance and Running Balance per account

You use this module to review and export purchase activity, not to create or edit transactions.

Modules connected to Purchase Journal

From the navigation and screen layouts, the Purchase Journal works together with:

  • Accounts Payable

    • Bills, Expenses, Cheque Voucher, Accounts Payable Vouchers, etc. – these modules record supplier and expense transactions that later appear as purchase entries.

  • General Accounting

    • Journal Entry – manual journals that affect purchase-related accounts.

  • Books of Original Entry

    • General Journal – all journal entries.

    • General Ledger – detailed account-by-account movement.

  • Accounting Setup

    • Chart of Accounts – defines the account codes and names shown in the Purchase Journal.

    • Period Setup / Period Closing / Manage Opening Balance – control which periods are open and where opening balances come from.

You will usually record purchases elsewhere (Bills, Expenses, Journal Entry), then review the accounting effect here in the Purchase Journal.


Key Features

  1. Date Range Filter

    • A date selector at the top lets you choose the period you want to review (for example, 2025-11-14 – 2025-12-14).

  2. Location Filter

    • A Location dropdown limits the report to a single location or shows All locations.

  3. Refresh Button

    • Refresh reloads the report using your selected date range and location.

  4. Export Options

    • Small icons beside Refresh allow you to export the report (for example, to a file you can download or share).

  5. Account Grouping

    • Transactions are grouped by account (card or block per account).

    • Each group has its Opening Balance, detailed lines, and a Closing Balance.

  6. Transaction Details

    • Standard columns:

      • Date

      • Description

      • Reference # (usually bill, voucher or journal number)

      • Debit

      • Credit

      • Running Balance per account

  7. Opening and Closing Balances

    • For each account, the report shows:

      • Opening Balance at the start of the selected period.

      • Closing Balance at the end of the period.


Getting Started

Before using the Purchase Journal, make sure the basics of your accounting setup are in place.

  1. Set up your Chart of Accounts

    • Go to Financials → Accounting Setup → Chart of Accounts.

    • Confirm that purchase-related accounts (e.g., Expenses, Inventory, VAT Control, Accounts Payable) exist.

  2. Define Accounting Periods

    • Go to Accounting Setup → Period Setup and add periods (start date, end date, status).

    • Ensure the period you want to view is Open.

  3. Enter Purchase Transactions

    • Record supplier bills and other purchases using:

      • Accounts Payable → Bill / Expense / Cheque Voucher / Accounts Payable Vouchers, and/or

      • General Accounting → Journal Entry (for adjustments or manual purchase entries).

    • In Journal Entry, make sure entries are Posted (not Draft) so they flow into reports.

Once those are in place, you’re ready to view the Purchase Journal.


How to Use

1. Open the Purchase Journal

  1. From the left menu, click Financials.

  2. Under Books of Original Entry, select Purchase Journal.

  3. The Purchase Journal page will load with default dates and location.

2. Set your filters

  1. Choose Date Range

    • Click the Date field at the top.

    • Select the start and end dates for the period you want to review.

    • Confirm your selection.

  2. Choose Location

    • Use the Location dropdown:

      • Select a specific location (e.g., branch or store), or

      • Choose All to see combined data.

  3. Apply Filters

    • Click Refresh.

    • The report reloads, grouped by account.

3. Read the report

For each account block (for example, Unmapped Account, VAT Control):

  1. Look at the Opening Balance row

    • This is the account’s balance at the start of your chosen period.

    • It usually comes from:

      • Prior-period closing balances, and/or

      • Manage Opening Balance for the first period.

  2. Review the transaction lines

    • Date – when the transaction is recorded.

    • Description – text from the bill, voucher, or journal (for example, Bill #3232323 VAT).

    • Reference # – the system or document number you can match with Bills, Expenses, or Journal Entries.

    • Debit / Credit – the amounts posted to this account.

    • Running Balance – the account’s balance after each line.

  3. Check the Closing Balance row

    • This shows the balance at the end of the period for that account.

  4. Scroll down to see other accounts

    • Each account relevant to purchases will appear in its own block.

4. Export the Purchase Journal

  1. With your filters set, click one of the export icons beside Refresh.

  2. Choose the export type (for example, a file you can download).

  3. Save the file to your computer.

  4. You can then use it for:

    • Internal review

    • BIR / regulatory submissions

    • Sharing with your accountant or auditor

5. Cross-check with related modules

To understand or verify numbers from the Purchase Journal:

  • Use Books of Original Entry → General Ledger

    • Check the movement for the same accounts (e.g., VAT Control, Expense accounts).

  • Use Books of Original Entry → General Journal

    • Confirm the underlying journal entries, especially if an amount came from a manual journal.

  • Use Accounts Payable modules (Bill, Expense, Cheque Voucher, etc.

    • Match Reference # and Description if you want to see the original transaction form.


Troubleshooting

1. “The report is empty – no transactions found.”

Possible causes and checks:

  • Wrong date range

    • Make sure the Date filter covers the days when you actually recorded purchases.

  • Wrong location

    • If you use locations, confirm that the Location filter is set correctly or set to All.

  • No posted transactions

    • Bills, expenses, or journal entries might not be created yet or may still be in Draft status:

      • Check Accounts Payable → Bill / Expense / Cheque Voucher / Accounts Payable Vouchers.

      • Check General Accounting → Journal Entry and post the entries if needed.

2. “Balances look incorrect for a specific account.”

Check the following:

  1. Opening Balance

    • Go to Accounting Setup → Manage Opening Balance and confirm the correct opening debit/credit.

  2. Account mapping

    • In Chart of Accounts, make sure accounts used for purchases, VAT, or payables are set up properly and active.

  3. Duplicate or wrong transactions

    • Look for duplicate bills, expenses, or journal entries with the same reference number.

    • Correct the source transaction (Bill, Expense, or Journal Entry).

    • The Purchase Journal will update after you Refresh.

3. “I can’t edit lines in the Purchase Journal.”

  • This module is report-only.

  • To fix an amount or description:

    1. Identify the Reference # and Description in the Purchase Journal.

    2. Go to the source module:

      • Accounts Payable (Bill, Expense, etc.), or

      • General Accounting → Journal Entry.

    3. Edit or reverse the transaction there.

    4. Return to the Purchase Journal, update the Date/Location filters if necessary, and click Refresh.

4. “Export file doesn’t match the screen.”

  • Confirm you refreshed the report after changing filters.

  • Re-export the file after the page shows the correct date range and location.

  • Make sure you’re not comparing it with a file exported earlier using different filters.


By understanding that the Purchase Journal is a central, read-only summary of all purchase-related postings, and by using its filters and connected modules (Accounts Payable, Journal Entry, General Ledger, Chart of Accounts, and Opening Balances), you can easily review, audit, and export accurate purchase information for each accounting period.

Did this answer your question?