Sales Journal

The Sales Journal Ready-to-Use Report shows sales journal entries for a selected period in a journal-style output that includes invoice or credit memo numbers, accounts, line descriptions, and debit and credit amounts.

Prerequisites

1. Latest Logicim XLGL version.
2. Microsoft Excel 2016 or higher.
3. A Sage 50 US company connected through Logicim XLGL.
4. Access to the Sage 50 US sales and accounts receivable data is included in the Accounts Receivable Ready-to-Use Reports group.

What the Report Does

The Report uses the Instructions worksheet to set start and end dates, then displays the selected period on the Report worksheet. The visible output includes the company name, Sales Journal Report title, period line, and columns for Date, Invoice/CM Number, Account ID, Account Description, Line Description, Debit, and Credit. The workbook also contains a hidden Data worksheet with sales transaction fields, including invoice number, date, customer ID, sales tax code, due date, discount date, ship-to fields, item ID, account ID, row type, amount, quantity, unit cost, and cost.

How to Use the Report

Step 1) On the Instructions worksheet, enter the reporting period in C8 for Start and C9 for End.

Step 2) Click Refresh on the XLGL ribbon to update the Report.

Step 3) Click Go to Report... on the Instructions worksheet to move to the Report output.

Step 4) Review the Report worksheet to confirm the company name, Report title, selected period, and grouping by Date, Invoice/CM Number, Account ID, and Account Description.

Step 5) Review Line Description, Debit, and Credit values for the sales tax, accounts receivable, inventory, sales, and cost entries listed for each invoice or credit memo.

Customization Options

Use the Start and End date inputs on the Instructions worksheet to change the reporting period. You can also use standard Excel formatting, filters, and layout adjustments on a copy of the workbook. For structural changes to the Report, use the customization link on the Instructions worksheet or request a Custom Report from Logicim.

Common Use Cases

1. Review sales journal entries for a selected accounting period.
2. Trace invoice and credit memo activity by account and line description.
3. Compare debit and credit postings for sales tax, accounts receivable, inventory, sales, and cost of sales lines.
4. Support period-end review by confirming that the Report period matches the dates entered on Instructions.

Troubleshooting

1. If the period in the Report is not what you expected, check the Start and End date cells in the Instructions and refresh the Report.
2. If the Report shows stale or unexpected values, confirm that Excel is connected to the correct Sage 50 US company through Logicim XLGL, then refresh again.
3. If sales journal rows are missing, confirm that the selected date range includes the transactions you expect to review.
4. If you need different columns, grouping, or calculations, request a Custom Report rather than editing the workbook’s formulas.

FAQs

1. Q: Which date range does the Report use? A: It uses the Start and End dates on the Instructions worksheet.
2. Q: Where can I review the output? A: Use Go to Report... on Instructions to move to the Report worksheet.
3. Q: Which columns are visible in the Report? A: The visible output includes Date, Invoice/CM Number, Account ID, Account Description, Line Description, Debit, and Credit.
4. Q: Can I change the Report structure? A: Use normal Excel formatting on a copy when needed. For column, grouping, formula, or layout changes, request a Custom Report.

Best Practices

1. Confirm the Sage 50 US company before refreshing the workbook.
2. Review the Start and End dates before using the Report for period-end work.
3. Refresh the Report after changing the date range.
4. Keep a backup copy before making Excel layout or formatting changes.
5. Compare the visible Debit and Credit amounts against the transactions or review totals you expect for the selected period.