Open Forum

Expand all | Collapse all

Budget Upload

  • 1.  Budget Upload

    GOLD CONTRIBUTOR
    Posted May 24, 2019 07:57 AM
    ​​Good morning.  I am attempting to upload data from Excel into a GP budget using the budget wizard for Excel.  The first error I receive states that the number of budget periods does not equal the number of Excel columns.  Has the template for upload changed?  We have Account, Description, Beginning Balance, a column for each month and a Total column.

    When I attempt to then access the Excel worksheet, I receive the message below regarding the worksheet.

    Any ideas on what is going on?  Thanks, Tracy



    ------------------------------
    Tracy Yaklyvich, MBA
    Controller
    American Society of Health-System Pharmacists
    Bethesda MD
    tyaklyvich@ashp.org
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Budget Upload

    TOP CONTRIBUTOR
    Posted May 24, 2019 09:20 AM
    Hi Tracy,

    Using the Budget Wizard for Excel, can you create a Blank Budget and use that as your 'template' instead?





    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    Chantilly VA
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Budget Upload

    GOLD CONTRIBUTOR
    Posted May 24, 2019 01:05 PM
    I had the same issue.  After looking at the columns the creator had added a small column or two for readability.  I agree that you may want to export out a blank budget to assure you have the exact number of columns.

    ------------------------------
    Michael Taranto, CPA
    President
    ERP Consulting, LLC
    Pataskala, OH 43062
    614-342-0098 mtaranto@erpconsultingLLC.com
    erpconsultingllc.com
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Budget Upload

    GPUG ALL STAR
    Posted May 27, 2019 06:55 PM
    Tracy

    Check the column headers in your excel import file.

    Sometimes GP experts out dates as your headers. There import routine can not process dates as labels.

    Change the headers to just month names or periods 1 -period 12
    And then try re-importing.

    Zubin

    ------------------------------
    Zubin Gidwani
    Founder
    Dynamic Budgets
    San Francisco-Bay Area CA
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Budget Upload

    Posted Jun 12, 2019 05:05 PM
    Tracy,

    I ran into the same thing today.  Make sure:

    1) Your headers are the same as the budget template
    2) Your headers are in "General" format (used to be it had to be in text)


    ------------------------------
    Kim Chambers
    TROSA
    Durham NC
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: Budget Upload

    TOP CONTRIBUTOR
    Posted Jun 12, 2019 10:56 PM
    Hey @Tracy Yaklyvich, MBA
    What we will do if our customers have issues with the operations people changing the template format is to put the template on Sheet2 of a spreadsheet, copy it to Sheet1, use basic formulas to link the two sheets then hide Sheet2.

    That way if they change something they shouldn't on Sheet1 they don't mess up the template.  When you unhide Sheet2 and look it over, any major changes they make will throw out issues with your calculation so they should show up fairly easily.

    Thanks
    Windi​

    ------------------------------
    Windi Epperson
    President/GP Senior Consultant
    Advanced Integrators, Inc.
    norman OK
    405-946-1774 ext. 102
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role