Logicim's ready-to-use Sage 50 US purchase journal

Purchase Journal

Purchase Journal is a report that lists purchase transactions recorded during a selected period, including details such as vendors, invoice numbers, dates, and amounts. It helps users review purchasing activity, track expenses, and verify accounts payable entries.

Prerequisites

  1. Microsoft Windows 10 Pro, Windows 11 Pro, or Windows terminal server (2012 and above)
  2. Microsoft Office 365
  3. Sage 50 US edition (2021 and above) 
  4. Internet connection

What the Report Does

This report provides a detailed breakdown of purchase transactions by account, showing invoice and credit memo activity along with the corresponding debit and credit entries. It helps users analyze how purchases are distributed across accounts, review accounting postings, and identify the accounts with the highest debit and credit amounts through summary charts.

How to Use the Report

Step 1) Enter the starting and end dates in C9 and C10.

Step 2) Click Refresh on the XLGL ribbon.

Step 3) Review the result:

a) Report

b) Chart

Customization Options

  1. Adjust the desired year in the Parameters sheet to generate data for a different period. 
  2. Select the column and row you want to filter by clicking the Autofilter

Common Use Cases

  1. Track and review vendor invoices and credit notes for a selected period.
  2. Monitor purchasing activity and vendor-level total spending.
  3. Analyze invoice trends and identify vendors with the highest invoice volume and amounts.

Troubleshooting

  1. Issue: No data is populated.
  2. Solution: Verify that the input parameters are correct and that the selected date range contains existing records.

FAQs

  1. Q: How can I filter the report?
  2. A: Click the arrow on any column to access the pivot table filtering option.

Best Practices

  1. Save a backup copy of the Report before making significant changes.
  2. Regularly review the report to track progress and identify trends early.
  3. Customize the report to focus on key performance indicators relevant to your business.
Related articles
Logicim's ready-to-use Sage 50 US comparative income statement
Logicim's ready-to-use Sage 50 US income statement 12 periods
Logicim's Ready-to-Use Sage 50 US Income Statement with Budgets
Logicim's Ready-to-Use Sage 50 US Aged Payable
Logicim's Ready-to-Use Sage 50 US Aged Receivable
Logicim's ready-to-use Sage 50 US commission Report
Logicim's Ready-to-Use Sage 50 US comparative balance sheet
Logicim's Ready-to-Use Sage 50 US Cash Flow
Logicim's Ready-to-Use Sage 50 US Sales Analysis
Logicim’s ready-to-use Sage 50 US balance sheet 12-month fiscal
Logicim's ready-to-use Sage 50 US purchase dashboard
Logicim's Ready-to-Use Sage 50 US Cash Receipt Journal
Logicim's ready-to-use Sage 50 US Vendor Invoice Log
Logicim's ready-to-use Sage 50 US Vendor Purchase and Outstanding
Logicim's ready-to-use Sage 50 US Invoice Register
Logicim's Ready-to-Use Sage 50 US Balance Sheet
Logicim's Ready-to-Use Sage 50 US Budget Report
Logicim's Ready-to-Use Sage 50 US Income Statement
Logicim's Ready-to-Use Sage 50 US Aged Payable- All transactions
Logicim's Ready-to-Use Sage 50 US Customer Invoice Log
Logicim's ready-to-use Sage 50 US Customer Management Detail
Logicim's Ready-to-Use Sage 50 US Customer Sales History
Logicim's ready-to-use Sage 50 US Item Sold to Customers
Logicim's ready-to-use Sage 50 US Items Purchased by Vendors
Logicim's ready-to-use Sage 50 US Proposal Report
Logicim's ready-to-use Sage 50 US Purchase Analysis
Logicim's ready-to-use Sage 50 US Sales
Logicim's ready-to-use Sage 50 US Sales and Outstanding Balances
Logicim's ready-to-use Sage 50 US Sales Journal
Logicim's ready-to-use Sage 50 US Sales Order
Logicim's ready-to-use Sage 50 US Sales Order Journal
Logicim's ready-to-use Sage 50 US Sales Order Register
Logicim's Ready-to-Use Sage 50 US Customer Standard Invoice Form
Logicim's Ready-to-Use Sage 50 US Dashboard Analysis
Logicim's ready-to-use Sage 50 US Inventory Analysis
Logicim's ready-to-use Sage 50 US Purchase Analysis (Intelligence Report)
Logicim's ready-to-use Sage 50 US Sales Analysis (Intelligence Report)
Logicim's Ready-to-Use Sage 50 US Balance Sheet Experimental
Logicim's Ready-to-Use Sage 50 US Income Statement Experimental
Logicim's Ready-to-Use Sage 50 US Income Statement with Budgets Experimental
Logicim's ready-to-use Sage 50 US Trial Balance Experimental
Logicim's Ready-to-Use Sage 50 US Inventory Analysis (Intelligence Report)
Logicim's Ready-to-Use Sage 50 US Cash Flow-Enhanced
Logicim's Ready-to-Use Sage 50 US Employee Compensation
Logicim's Ready-to-Use Sage 50 US General Ledger
Logicim's Ready-to-Use Sage 50 US Payroll Register
Logicim's ready-to-use Sage 50 US Inventory Assemblies on Order
Logicim's ready-to-use Sage 50 US Inventory on Hand Analysis
Logicim's ready-to-use Sage 50 US Inventory Profitability
Logicim's ready-to-use Sage 50 US Inventory Stock Status
Logicim's ready-to-use Sage 50 US Item List
Logicim's ready-to-use Sage 50 US Items Sold to Customers by Location
Logicim's ready-to-use Sage 50 US Job Ledger
Logicim's ready-to-use Sage 50 US Job Profitability
Logicim's ready-to-use Sage 50 US Job Register
Logicim's ready-to-use Sage 50 US Trial Balance

Edited: Monday, August 31, 2026

Was this article helpful?

Thank you! Your feedback matters.

We'd love to hear your thoughts! Please provide a comment before submitting.

Thank you for your message!

Would you like a Logicim team member to reply to your message?

If so, please enter your email address below.

You will also receive a copy of your comment.

We protect your personal information.

Thank you for your message!

Verify your inbox or spam folder to find the copy of your comment.
Contact clientcare@logicimtech.com if you didn't receive it.

Contact support@logicimtech.com for technical support or reporting questions.
Book your FREE consultation now with a Logicim Sage 50 Reporting EXPERT.

Fullscreen Image