Mapped balance sheet 

This report helps in grouping desired accounts in a balance sheet for easier viewing. 

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 Mapped balance sheet is your best tool for creating reports without the hassle of reviewing every individual account. It enables you to group accounts with similar functions. Though this cuts through the hassle, it is also important to ensure that grouped accounts align like an actual balance sheet. 

How to use the report? 

1. Input the date in cell D1 of the Balance Sheet worksheet. 
2. Add the connection name you want to use in cell C1. 
3. Once entered, the values will be calculated automatically. 

Customization options  

Go to the Mapping worksheet. 

Set accounts to be grouped in column B or C. If you prefer not to use a series of accounts (as shown in the example below), set the accounts to be grouped and use commas to separate them. 

Set the connection name in cells B1 and C1 to get your intended account groups. 

You can also add more account name rows to this report as needed.  

Common use cases  

This report is especially useful when condensing a balance sheet for stakeholder presentations. 

Troubleshooting  

1. Issue: No values appear even after clicking Refresh on the XLGL ribbon. 
2. Solution: Ensure that cell C1 contains a valid connection name and cell D1 includes a date within your current or historical fiscal years. The connection name and date must match the data available in the Sage 50 company file you’ve set up. 

FAQs 

1. Q: How do I edit account group names? 
2. A: 

First, note the account group name you want to change—for example, Accounts receivable. 

Go to the Mapping worksheet and update the name (example, change it to Accounts receivable current). 

Once updated, copy the new name and paste it into the corresponding row on the Balance Sheet worksheet, replacing the previous group name. 

Best practices   

Ensure the account group names you set up are easy to recognize, as this simplifies customization.