Monday, October 3, 2011

Reconciling GL & AP Data

by Marc Hall, Sage Accpac Consultant
Last week, I spent some time reconciling a client’s Sage ERP Accpac AP aging to their GL. Below is the process I used:
  1. Look for GL (or non-AP) transactions in the GL.
  2. Query the AP Posting Journal Details (APPJD) table for instances where the AP Control account was posted to but the Account Type was 2, indicating that the control account was used as the offset account (in the grid) to an AP transaction (where APPJD.ACCTTYPE = 2). I’ve seen this most often on AP Adjustments.
  3. Query the AP Posting Journal Details table where the account is the AP control account and paste in to sheet1 in Excel. Query the GL Posted Transactions table where the account is the AP Control account (GLPOST.ACCTID) and post in to sheet 2.
  4. I then summed both sheet1 and sheet 2 by Source Type so that I could determine the total of IN, PY, AD, CR, and JE entries I had in each and I compared the APPJD summary to the GLPOST summary to identify which Source Types differed.
  5. For those Source Types that differed, I copied out just those transactions to a separate sheet (one for APPJD and one for GLPOST) and sorted by transaction date and amount so that they should line up. I then copied the transaction amount column from APPJD to GLPOST and looked for differences. When I found differences (e.g. posted in AP but not GL), I investigated the batch-entry in AP and GL to see what happened.
Post a comment and let me know if you've done anything similar or different when reconciling GL & AP data in Sage Accpac. 


  1. The greatest assets which any nation can have are the guiltless' personalities of their children. Contribute mood learning re the order of them, taking into consideration they will future motivate regarding your nation as pioneers, and you don't need worthless personalities as obscure to read for statement of purpose for internship sample

  2. Notwithstanding, one of the difficulties of a PC application is that the PPT archives can't be shared and printed effectively. This arrangement contains sight and sound substance or illustrations which may vanish or get misprinted when it is sent or printed.pdf to ppt

  3. Thanks for sharing this, Each account can hold the current balance, all the debits and credits to the account in each fiscal period, historical data, and budget data, get more info

  4. Hence I need to acquaint an advantageous strategy with consolidate documents into one is to utilize PDF creator.

  5. This comment has been removed by the author.

  6. The technology apparatuses, for example, Inspiration® technology, Starry Night, A WebQuest and Portaportal enable understudies to utilize an assortment of techniques, for example, request, critical thinking, innovative reasoning, visual symbolism, basic reasoning, and hands-on movement.

  7. An explanation in simple terms of 2G and 3G Technology and what they mean for you in today's world. You will see how 3G Phones offer fantastic features including photo-editing, 508 presentations and the World Wide Web. You can keep in touch with your friends with digital photos and other communications.