Open Forum

Expand all | Collapse all

Budget Upload

  • 1.  Budget Upload

    Posted 27 days ago
    ​​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
    American Society of Health-System Pharmacists
    Bethesda MD
    GPUG Summit - Post

  • 2.  RE: Budget Upload

    Posted 27 days ago
    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

    GPUG Summit - Post

  • 3.  RE: Budget Upload

    Posted 27 days ago
    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
    ERP Consulting, LLC
    Pataskala, OH 43062

    GPUG Summit - Post

  • 4.  RE: Budget Upload

    Posted 23 days ago

    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 Gidwani
    Dynamic Budgets
    San Francisco-Bay Area CA

    GPUG Summit - Post

  • 5.  RE: Budget Upload

    Posted 8 days ago

    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
    Durham NC

    GPUG Summit - Post

  • 6.  RE: Budget Upload

    Posted 7 days ago
    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.


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

    GPUG Summit - Post

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