| Overview |
If your B40 Audit Plan or lead schedules in BTCSoftware are not populating with figures from the trial balance, this is almost always caused by an incomplete or incorrect mapping between the trial balance accounts and the lead schedule lines. This article explains how to check and fix the mapping.
| Understanding How Lead Schedules Populate |
Lead schedules in BTCSoftware pull their figures from the trial balance. For a figure to appear on a lead schedule, the corresponding trial balance account must be mapped to that schedule. If the mapping is missing or incorrect, the lead schedule will appear blank or show zero.
| How to Check and Fix the Mapping |
- Open the accounts task in BTCSoftware.
- Go to the Extended Trial Balance.
- Switch to Edit mode.
- For each account line in the trial balance that should populate the lead schedule, check the Lead Schedule column (or Mapping column).
- If the Lead Schedule column is blank for a line that should populate a schedule, click the field and select the correct lead schedule from the dropdown.
- Save the mapping.
- Return to the lead schedule — it should now show the figures from the mapped trial balance accounts.
| ✔ Tip: Work through the trial balance systematically, line by line. It is common for one or two lines to be unmapped while the rest are correctly configured — a single missing mapping can cause a schedule to appear blank. |
| B40 Audit Plan Not Populating |
The B40 Audit Plan draws figures from the lead schedules, which in turn draw from the trial balance. If the B40 is blank or showing zeros:
- First confirm that the lead schedules themselves are populating correctly — check a specific lead schedule before investigating the B40.
- If the lead schedules are empty, fix the trial balance mapping as described above.
- If the lead schedules are showing figures but the B40 is not, check that the lead schedule lines are mapped to the correct B40 sections.
- Go to the B40 mapping settings and confirm each section is linked to the appropriate lead schedule.
- After correcting the mapping, re-run the B40 population.
| Wrong Dataset Selected |
Another common cause of lead schedules not populating is having the wrong dataset or accounting period selected. Confirm that:
- The trial balance figures are entered under the correct accounting period.
- The lead schedule is viewing the same accounting period as the trial balance.
| 💬 Suggested Chatbot Answer |
| If your B40 or lead schedules are not pulling figures from the trial balance, the most common cause is a missing mapping. Open the Extended Trial Balance, check the Lead Schedule mapping column for each account line, and assign the correct schedule where it is blank. Here is the full guide: [link]. |
| Frequently Asked Questions |
Q: The lead schedule was working last year but is not working this year — what has changed?
A: When rolling forward to a new year, mappings should carry forward automatically. However, if new account lines have been added to the trial balance for the current year, they will not be mapped automatically. Check the new lines and map them to the appropriate lead schedules.
Q: I have fixed the mapping but the lead schedule is still blank — what else should I check?
A: Confirm there are actual figures in the trial balance lines you have mapped. A correctly mapped line with zero or blank figures will still produce a blank schedule. Also check that you have saved the mapping changes before viewing the schedule.
Q: Can I map one trial balance account to multiple lead schedules?
A: No. Each trial balance account can only be mapped to one lead schedule. If a balance needs to appear on multiple schedules, it will need to be split across separate account lines.