Financial Report – Not Balancing

  • Financial Report – Not Balancing

    Posted by gregory-cara on December 13, 2016 at 12:36 pm
    • Cara Gregory

      Member

      December 13, 2016 at 12:36 PM

      Hello,

      I am struggling with a financial report that normally balances out to zero each month. In October it had a balance of six cents and in November is has a balance of seven cents. My G/L balances and ties out to the accounts on the report. The admin & management fees at the top come from a spreadsheet calculation – I have manually added the entire year’s spreadsheet and come up with the total on this report. I am wondering if something is funny in the Advanced Financial setup or if something went awry with the integration that we use for the admin/management fees. I’m not sure how else to troubleshoot my issue.  Attached is an image of the report. Thank you in advance. mvmsOzM6T1mHGtv5tW9I_PL AMCO.png

      ——————————
      Cara Gregory
      Accountant
      Alvarado Management Company
      Albuquerque NM
      ——————————

    • Frank Heslin

      Member

      December 13, 2016 at 7:15 PM

      Hi Cara,

      In the past when I have run into similar situations, I ended up finding out the some transactions had been entered with more than two decimal places.  I would start with accounts like taxes, that are based on a calculation, to see if any totals have a number other than zero in the 3rd or 4th decimal place.  You may eventually need to look directly into the GP tables to find it. 

      Hope this helps!

      ——————————
      Frank Heslin
      Financial Systems Administrator
      ExamWorks, Inc.
      Atlanta GA

      Member, GPUG Advisory Committee
      Chairman, Georgia Regional GPUG Chapter
      Summit 2016 Track Leader

      GP2015 R2
      MR CU14

      Follow me on Twitter: @Automate_It

      GPUGGA – http://www.gpug.com/Atlanta

      *** Help Us, Help You…provide enough info so that we don’t have to ask for more:) ***
      *** If you solve your issue please share the solution to assist others! ***
      ————————————————————————-

    • Cara Gregory

      Member

      December 14, 2016 at 10:27 AM

      Thank you Frank.

      ——————————
      Cara Gregory
      Accountant
      Alvarado Management Company
      Albuquerque NM
      ————————————————————————-

    • Cara Gregory

      Member

      December 14, 2016 at 1:46 PM

      I finally found it. 🙂

      ——————————
      Cara Gregory
      Accountant
      Alvarado Management Company
      Albuquerque NM
      ————————————————————————-

    • Frank Heslin

      Member

      December 15, 2016 at 11:39 AM

      Awesome!  Was that what happened?

      ——————————
      Frank Heslin
      Financial Systems Administrator
      ExamWorks, Inc.
      Atlanta GA

      Member, GPUG Advisory Committee
      Chairman, Georgia Regional GPUG Chapter
      Summit 2016 Track Leader

      GP2015 R2
      MR CU14

      Follow me on Twitter: @Automate_It

      GPUGGA – http://www.gpug.com/Atlanta

      *** Help Us, Help You…provide enough info so that we don’t have to ask for more:) ***
      *** If you solve your issue please share the solution to assist others! ***
      ————————————————————————-

    gregory-cara replied 7 years, 4 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Financial Report – Not Balancing’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!