We recommend testing the import of the entry, prior to removing the temporary budget and posting the new approved budget.
Step 1: Test the entry is balanced. Upload an entry from Excel, but hit cancel and clear, rather than post.
Step 2: Posting an entry to reverse the temporary budget. reversing the entry.
Step 3: Upload the budget entry that we tested in step 1, but this time, click post.
STEP 1: TESTING THE BUDGET ENTRY
- Go to the Budget Journal Tab.
- Upload excel from the bottom of the screen.
- Touch browse, select your file and sheet. Click Load.
The screen will prompt you to confirm your columns. The starting row defaults to Row 2, but to change that, highlight the row you want to start at. The number in the box will change.
- Click Import. Review the debits to credits and make sure it matches.
If the entry is not balanced, check the account numbers. Chances are one is missing or has a typo. If there is a new account number added to the budget, make sure it is in the Chart of Accounts.
- Click Cancel and Clear, as this post WAS ONLY A TEST to see if the entry balances in the system.
STEP 2: REVERSING THE TEMPORARY BUDGET
- Create a reversing entry to remove your temporary budget.
Select Journal/Budget from the top menu bar. Choose Budget Functions, then Create an Entry to Remove Budget.
- Enter your fund. You will receive a prompt:
– Click NO for current year budget only – Click YES for AR budget.
- The entry will load- make sure it is correct and hit post.
- You are going to get a warning that you are over-expending your accounts, you will need to enter your override password.
***You are emptying your accounts, so this is true, for the moment.***
STEP 3: POSTING THE BUDGET ENTRY:
- Repeat step one, except click POST when complete, not “Cancel”.
Was this helpful?
0 / 0