--- title: "Manage Imbalance on Creditors Control Notification" canonical: "https://kb.myframeworks.com.au/space/FRAM/28397798/Manage%20Imbalance%20on%20Creditors%20Control%20Notification" format: markdown --- To ensure financial accuracy, our **Creditors Control Account Notifications **provide a daily summary of key account movements from the previous day’s trade. By tracking discrepancies or imbalances in the creditors control accounts, this notification helps identify potential issues early, ensuring smooth financial operations and better decision-making. This article is intended to help investigate the reason behind an imbalance in the Creditors Control Account Notification task. ## Prerequisite #### Creditors Control Audit To ensure there is creditor control data available to be reported on, you must run the **Creditors Control Audit** schedule task at the end of each day’s trade. This task totals up the Creditors subledger for a company and compares it to the GL balance for your Trade Creditors. To allow for variances between these accounts to be tracked, we recommend scheduling this task to run daily at around 8 pm and setting the schedule to email the report to your accounts team. Your accounts team will be notified, via email, if the Creditor Control Audit from the day trade was Balanced or Imbalanced. #### Creditors Control Account Notifications In addition to scheduling the Creditors Control Audit task, we also recommend scheduling the **Creditors Control Account Notifications** report to run daily at 6 am and setting the schedule to email the report to your accounts team. By default, the report is set to report on the last 60 days of Creditors Control Audits. > ⚠️ **Important:** The Creditors Control Account Notifications report can only display data starting from the date when the Creditors Control Audit scheduled task was first activated. > ✅ Refer to [https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28390922](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28390922) on how to run this report. > Macro (excerpt) > > # Steps to Manage Imbalance on Creditors Control Notification > > To manage the imbalance in Creditors Control Notification, open Frameworks and follow the steps below: > > > 📝 ## Quick Steps > > 📝 > > 📝 Here are quick instructions to help you manage imbalances on the Creditors Control Notification: > > 📝 > > 📝 1. **[Check the Creditors Control Audit Notification](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397798/Manage+Imbalance+on+Creditors+Control+Notification#step1)** > > 📝 - Navigate to **System Administration > Task Scheduler > Task Scheduler Queue**.** ** > > 📝 - Find the **CreditorControlSched **task to view the notification. > > 📝 2. **[Run the Creditor Control Notifications report](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397798/Manage+Imbalance+on+Creditors+Control+Notification#step2)** > > 📝 - Open the **Report Category List **and select **Creditors Control Account Notification** to identify the day the Creditors Control Account went out of balance. > > 📝 - If the **A/P Close Balance** matches the **Creditors Account Values**, no further action is required. If they don’t match, proceed with the next steps. > > 📝 3. **[Review Journals in the GL Dashboard](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397798/Manage+Imbalance+on+Creditors+Control+Notification#step3)** > > 📝 - Open the **GL Dashboard** and search for the Trade Creditor Account. > > 📝 - Filter the account by the day or month the imbalance began. > > 📝 - Ensure no journals are posted to Control Accounts. > > 📝 - If journals are posted, investigate, reverse them, and resolve the issue. > > 📝 4. **[Run the Supplier Invoice Listing Report](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397798/Manage+Imbalance+on+Creditors+Control+Notification#step4)** > > 📝 - If no GL journals are found for the affected day or month, run the **Supplier Invoice Listing** report from the **Report Category List**. > > 📝 - Compare the report results with the invoice postings. > > 📝 5. **[Match Supplier Payments in the Payments Enquiry Screen](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397798/Manage+Imbalance+on+Creditors+Control+Notification#step5)** > > 📝 - If the imbalance persists, go to the **Payments Enquiry** screen and match the Supplier Payments with the Direct Deposit postings. > > 📝 6. **[Contact Support](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397798/Manage+Imbalance+on+Creditors+Control+Notification#step6)** > > 📝 - If the imbalance cannot be found, contact the [Support ](https://kb.myframeworks.com.au/page/support)Team. ## Detailed Steps ### > Macro (anchor) 1. Check the Creditors Control Audit Notification If you missed the notification email or you just want to review the Creditors Control Audit Notification from the end of a particular day there are 2 ways to check the Creditors Control Notification output from the **Task Scheduler Queue** screen. 1. Click the **Frameworks Menu** and enter **Task Scheduler Queue** in the **Search Box.** 2. Click the **Frameworks Menu **and navigate to **System Administration > Task Scheduler > Task Scheduler Queue** from the navigation tree. To view this report, perform the following steps: > ⚠️ **Note**: The Creditors Control Audit task needs to be run to see this report. 1. In the **Search **fields at the top, enter **Creditor** in the **Name** field and leave the **Created By** and **Scheduled** fields blank. 2. Click **Find** to filter and display the results. 3. From the Results Grid, click the **CreditorControlSched** link. 4. Go to the **Output** tab, then click on the hyperlink to download the report. 5. Open the **Generated Report**. 6. Check if the **Cr Close Balance** and **Creditors Account Values** match. > ℹ️ If the **Cr Close Balance** and **Creditors Account Values** match, there is no issue, and no further action is required. If there is a mismatch, proceed to the [next steps](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397798/Manage+Imbalance+on+Creditors+Control+Notification#step2). ![image-20240924-235854.png](media://a174175a-12f3-4e8d-b340-4a20d2c79f4a) --- ### > Macro (anchor) 2. Run the Creditor Control Notification report The **Creditors Control Account Notifications** report extracts the details from the Creditors Control Audit Notification task, typically for the last 60 days. This allows for variances to be tracked to the particular day they started. To rerun this report, perform the following: 1. From the **Dashboard Icons** on the **Home **screen, select the **Report Category List** icon. 2. In the **Search **bar at the top of the grid, enter **Creditors Control** in the **Name** or **Description** column. 3. In the **Report Name **column, click the **Creditors Control Account Notifications** hyperlink. 4. In the **Report Criteria** tab, enter the required parameters for the report you have chosen to run. 5. Click **Submit **to run the report as a once only report. 6. After running the report, the **Output **tab displays the results of the completed task and a link to download the selected report output under the **Generated Reports** section. 7. Open the report and determine when the control account became imbalanced. --- ### > Macro (anchor) 3. Review Journals in the GL Dashboard To further investigate the imbalance, check if there is an existing Journal. 1. From the **Dashboard Icons** at the top of the screen, click the **GL Dashboard **icon. 2. In the **Search** fields, search for your **Trade Creditor account.** > ✅ Refer to [https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397388](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397388) for more information on how to refine your search. > ℹ️ If it’s been renamed, go to **Company Maintenance** and copy the account number from the **Creditors Control** field. 3. Filter the account by the day or month the imbalance started and check for any Journal postings. > ⚠️ GL Journals should not be posted to Control Accounts. **If there are any Journals:** - Determine the reason they were posted to the Control account. - Reverse the Journal and fix the issue. **If there are no Journals, proceed to the ****[next step](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397798/Manage+Imbalance+on+Creditors+Control+Notification#step4)****.** --- ### > Macro (anchor) 4. Run the Supplier Invoice Listing Report. The **Supplier Invoice Listing** report is a simple list of open supplier invoices dated up to and including the nominated cutoff date. It displays the total of each invoice, a supplier subtotal and a total of the invoice amounts. 1. From the **Dashboard Icons** on the **Home **screen, select the **Report Category List** icon. 2. In the Search bar at the top of the grid, enter ”Supplier Invoice Listing” in the **Name** or **Description** column. 3. Click the **Report Name** hyperlink. > ✅ Refer to [https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28398448](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28398448) for more information. --- ### > Macro (anchor) 5. Match Supplier Payments in the Payments Enquiry Screen If there is still no sign of the imbalance, go to the **Payments Enquiry** screen and match the **Supplier Payments** with the **Direct Deposit** postings. --- ### > Macro (anchor) 6. Contact the Support Team. Log a [support request](https://kb.myframeworks.com.au/page/support) to ask for assistance if the imbalance still cannot be found.