Overview
The Sales Journal in DizLog is part of Financials → Books of Original Entry.
It shows all sales-related accounting entries for a chosen date range and location, laid out in a format that is BIR-aligned and export-ready.
Each section of the report groups transactions by account (for example, Unmapped Account, VAT Control) and shows the opening balance, each journal line, and the closing balance.
Key Features
Sales Journal report (BIR-aligned)
Tabular report of sales-related journal entries.
Columns include Date, Description, Reference #, Debit, Credit, and Running Balance.
Each account section shows Opening Balance and Closing Balance.
Flexible filters
Date range: choose the period you want to review (for example, a month or quarter).
Location: view All locations or a specific branch/site.
Per-account groupings
Transactions are grouped under account headers such as Unmapped Account and VAT Control.
Each group displays its own running balance and closing balance.
Export options
Download button to export the report data (for use in spreadsheets or external systems).
PDF button to generate a print-ready copy of the Sales Journal.
Connected modules
The Sales Journal doesn’t create transactions itself. It shows journal entries created elsewhere in the system, including:Sales / POS – when you record sales, the system posts accounting entries that appear here.
General Accounting → Journal Entry – manual journals tagged as sales will flow into the Sales Journal.
Accounting Setup → Chart of Accounts – defines the accounts and posting rules (for example, events like SALE and VAT accounts) that determine how sales transactions are recorded.
Books of Original Entry → General Journal, Purchase Journal, General Ledger – use these related books to cross-check totals and other types of entries.
Getting Started
Before using the Sales Journal, make sure:
Your chart of accounts is set up
Go to Financials → Accounting Setup → Chart of Accounts.
Ensure you have the sales revenue accounts, VAT control accounts, and other related accounts configured.
Check Posting Rules so that sales events (for example, SALE) have correct debit and credit accounts.
Sales transactions are being recorded
Enter sales in your Sales or POS modules, or
Post manual sales journals under General Accounting → Journal Entry.
(Optional) Opening balances are entered
If you migrated from another system, add starting balances under
Financials → Accounting Setup → Manage Opening Balance so that the opening balances in the Sales Journal are accurate.
Accessing the Sales Journal
From the left menu, go to:
Financials → Books of Original Entry → Sales Journal.
How to Use
1. Choose your report filters
Open Sales Journal.
At the top of the page, set your Date range:
Click the date range field.
Choose the start date and end date you want to include.
Select Location:
Leave as All to view every location, or
Choose a specific branch/site from the dropdown.
Click Refresh to load or update the report.
2. Understand the layout
For each account section (for example, Unmapped Account, VAT Control), you will see:
A small header with:
Opening Balance
Closing Balance
A detailed table with columns:
Date – the transaction date.
Description – a short text such as an invoice or bill description.
Reference # – usually the document or journal reference number.
Debit – debit amount posted to this account.
Credit – credit amount posted to this account.
Running Balance – the balance of the account after each line.
You can scroll down to see all accounts included in the period.
3. Review sales activity
Use the report to:
Check daily sales entries
Look at the rows under your revenue and VAT accounts.
Confirm that dates, descriptions and reference numbers match your invoices or POS transactions.
Confirm account balances
Compare the Closing Balance of each sales-related account with:
Books of Original Entry → General Ledger, and
Period-End Reports → Profit & Loss (for revenue totals).
Differences often mean filters (dates or locations) are not aligned between reports.
Review VAT and other control accounts
Use sections like VAT Control to confirm tax amounts recorded from sales.
4. Export the Sales Journal
To keep records or share with your accountant:
Apply your filters (date and location) and click Refresh.
Click the Download icon to export the data file (for use in spreadsheets).
Click the PDF icon to generate a PDF version for printing or electronic filing.
Troubleshooting
1. The Sales Journal is empty
Check the following:
Date range – make sure you’ve selected a period that actually contains sales.
Location – if you use multiple branches, try setting Location to All.
Posted sales – confirm that:
Sales or POS transactions were created, or
Journal entries for sales were posted under General Accounting → Journal Entry.
If there are no sales entries in those modules, nothing will appear in the Sales Journal.
2. Transactions show under “Unmapped Account”
“Unmapped Account” means the system couldn’t assign a transaction to a specific account.
What to do:
Go to Accounting Setup → Chart of Accounts.
Open the relevant revenue or VAT accounts.
Check the Posting Rules:
Ensure events like SALE (or other sales-related events) have valid Debit Account and Credit Account settings.
Post a new test sale and check the Sales Journal again.
Note: Existing “unmapped” entries may need a correcting Journal Entry to move them into the proper account.
3. Totals don’t match Profit & Loss or General Ledger
If Sales Journal totals differ from other reports:
Confirm that the date range is the same in:
Sales Journal
Profit & Loss
General Ledger
Make sure the Location filter matches across all reports (for example, All vs. a specific branch).
Check if some sales were recorded via:
Manual journals only (visible in General Journal/General Ledger), or
Sales/POS in a different location than the one selected.
4. Export buttons don’t work
If clicking Download or PDF does nothing:
Wait a moment; large reports may take time to generate.
Ensure your browser allows file downloads.
Try refreshing the page and running the report again.
By following this guide, you can use the Sales Journal to review sales-related entries, verify balances with the General Ledger and Profit & Loss, and generate export-ready records for compliance and reporting.