Logicim’s ready-to-use Sage 50 CA physical count worksheet

Physical count worksheet 

This Report provides an overview of your inventory and an option to change your inventory numbers. 

Prerequisite 

  1. Logicim XLGL version 5.0 or higher 
  2. Microsoft Excel 2016 or higher              
  3. Sage 50 Canadian Edition (2014 and above) 

What the Report does  

The Physical count worksheet presents an overview of your inventory and also an option to change the numbers depending on your actual physical count. 

How to use the Report  

  1. After selecting the correct company, click the Refresh button on the Logicim XLGL ribbon. 
  2.  picture
  3. Then, view the Reports by clicking Go to Report… or by just clicking the Report worksheet. 
  4.  picture

Common use cases  

The Report provides an overview of inventory, including services. It assists with experimental adjustments (addition or subtraction) to your current inventory, displaying real-time changes in physical count and value as encoded in Sage 50. 

Troubleshooting  

  1. Issue A: No values appear on the worksheet.  
  2. Solution A: Ensure that your account has the necessary permissions to access the Accounts & General ledger. 

FAQs  

  1. Q: Can I only see Services on the Report? 
  2. A: The Report is designed to only show inventories though a specialist can help you with that: link


  1. Q: Can I have this Report customized for a specific date range? 
  2. A: The Report is designed to pull data based on the session date from your Sage 50 company. If you want it to be customized further, you can request it here: link. 

Best practices 

Connect to the right company before loading this Report. Ensure that the Refresh after opening checkbox is checked. This allows the Report accurate company-wise and saves you some steps such as clicking the Refresh button on the Logicim XLGL ribbon. 

picture

Related articles

No related articles found

Edited: Wednesday, July 30, 2025

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.