cats:analytics:glandinventory

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
Last revisionBoth sides next revision
cats:analytics:glandinventory [2019/04/17 16:12] – [Current Balance Issues] amandacats:analytics:glandinventory [2019/04/18 13:50] – [Causes of Discrepancies] amanda
Line 12: Line 12:
 Follow these steps to attempt to find the cause. Follow these steps to attempt to find the cause.
 ===Compare the Ending balances in the end-of-fiscal-year Isolated area to the Opening balances in the Current area=== ===Compare the Ending balances in the end-of-fiscal-year Isolated area to the Opening balances in the Current area===
 +  -**From the isolated area, print a Trial Balance.**
 +      * In the filter for **G/L Accts Bal/Act**, select **Current/Opn Bal**.
 +      * Choose columns for **Opening Balance**, **Period 11 Balance**, **Period 12 amount**, and **Period 12 balance** (or **Current Balance**) - or whichever period is the one you need to balance.
   -**From the current area, print a summary report of open invoices.**    -**From the current area, print a summary report of open invoices.** 
     * Under the **Invoice Type** filter choose either Purchases or Sales.      * Under the **Invoice Type** filter choose either Purchases or Sales. 
Line 18: Line 21:
     * On **Screen 5**, choose **Summary**.     * On **Screen 5**, choose **Summary**.
     * On the **Select Order** screen, order and subtotal by **Account**.     * On the **Select Order** screen, order and subtotal by **Account**.
-    * Print the report and note the bottom total.  +    * Print the report and note the bottom total.   
-  -**From the fiscal year-end isolated area, print a summary report of open invoices.**  +
-      * Under the **Invoice Type** filter choose either Purchases or Sales.  +
-      * Under **Balance** filter select **Balance All**.  +
-      * Select one G/L account, for either the GL_AP or GL_AR system account. +
-      * On **Screen 5**, choose **Summary**. +
-      * On the **Select Order** screen, order and subtotal by **Account**. +
-      * Print the report and note the bottom total.+
   -**From the isolated area, print a G/L Statement.**   -**From the isolated area, print a G/L Statement.**
     * In the filter for **G/L Account Range**, select the G/L account for GL_AR or GL_AP.     * In the filter for **G/L Account Range**, select the G/L account for GL_AR or GL_AP.
     * Choose columns for **Opening Balance**, **Debit**, **Credit**, and **Current Balance** (or whichever period is the one you need to balance, such as **Period 12 balance**).     * Choose columns for **Opening Balance**, **Debit**, **Credit**, and **Current Balance** (or whichever period is the one you need to balance, such as **Period 12 balance**).
 +    * On **Screen 5**, choose **Summary**.
 +    * On the **Select Order** screen, order and subtotal by **Account**, then order by **Invoice Number**.
   -**Compare the totals for each report to one another.**      -**Compare the totals for each report to one another.**   
     * Once you find a discrepancy, narrow down the issue to one account (if possible).     * Once you find a discrepancy, narrow down the issue to one account (if possible).
-    * Print the invoices just for that counterparty account code using the **Account Range** on the reports. +    * Print the detailed list of invoices just for that counterparty account code using the **Account Range** on the reports.  
 +    * Do the same with the G/L statement. 
     * Then, you can determine which invoices have balance discrepancies.     * Then, you can determine which invoices have balance discrepancies.
 ====Current Balance Issues==== ====Current Balance Issues====
Line 40: Line 39:
   - **Fix these transactions.**    - **Fix these transactions.** 
       * [[:cats:procedures:accounting:transactions:modifydelete#reversing_voiding_a_posted_transaction|Follow these steps to reverse them]] **//OR//**        * [[:cats:procedures:accounting:transactions:modifydelete#reversing_voiding_a_posted_transaction|Follow these steps to reverse them]] **//OR//** 
-      * [[cats:questions:accounting:readaccountrecalc#reading_and_correcting_errors_on_the_report|Correct these errors]].+      * [[cats:questions:accounting:readaccountrecalc#reading_and_correcting_errors_on_the_report|Correct these errors by entering an alternate G/L number for these transactions]].
 ===Compare the Ending balances in the end-of-fiscal-year Isolated area to the Report of Open Invoices=== ===Compare the Ending balances in the end-of-fiscal-year Isolated area to the Report of Open Invoices===
   - **From the current or an isolated area, print a summary report of open invoices.**    - **From the current or an isolated area, print a summary report of open invoices.** 
Line 49: Line 48:
       * On the **Select Order** screen, order and subtotal by **Account** then order by **Invoice Number**.       * On the **Select Order** screen, order and subtotal by **Account** then order by **Invoice Number**.
       * Print the report and note the bottom total.        * Print the report and note the bottom total. 
-  - **Also from the isolated area, print a Trial Balance.** +  - **From the isolated area, print a G/L Statement.** 
-      * In the filter for **G/L Accts Bal/Act**, select **Current/Opn Bal**. +      * In the filter for **G/L Account Range**, select the G/L account for GL_AR or GL_AP. 
-      * Choose columns for **Opening Balance**, **Period 11 Balance**, **Period 12 amount**, and **Period 12 balance** (or **Current Balance**) - or whichever period is the one you need to balance.+      * Choose columns for **Opening Balance**, **Debit**, **Credit**, and **Current Balance** (or whichever period is the one you need to balance, such as **Period 12 balance**).
       * On **Screen 5**, choose **Summary**.       * On **Screen 5**, choose **Summary**.
       * On the **Select Order** screen, order and subtotal by **Account**, then order by **Invoice Number**.       * On the **Select Order** screen, order and subtotal by **Account**, then order by **Invoice Number**.
Line 59: Line 58:
       * Print the invoices just for that counterparty account code using the **Account Range** on the reports.        * Print the invoices just for that counterparty account code using the **Account Range** on the reports. 
       * Then, you can determine which invoices have balance discrepancies.       * Then, you can determine which invoices have balance discrepancies.
 +
 +====Causes of Discrepancies====
 +Here are some of the most common causes of balance discrepancies on invoices in CATS.\\ 
 +  - Incorrect postings to GL_AP and GL_AR accounts.
 +  - Changes to invoices in isolated areas that were not done in the current area.  
 +      * Invoices unposted/deleted from isolated areas that are in the current area (or vice versa).
 +      * Modifications to invoices in isolated areas that were not carried to the current area, including changing G/L number or changing amounts.
 +  - Failure to re-isolate correctly after making changes to the current area that affect the isolated area. 
  • cats/analytics/glandinventory.txt
  • Last modified: 2019/04/18 14:04
  • by amanda