Budget File Maintenance Questions & Answers

Release Date: 6/20/2017

Q - My accounting year is May 1 thru April 30. We haven't yet closed the year just ended on 4/30/17, so there are dollar amounts in most accounts.

A - You may run Export Processor to retrieve year 2017 account balances as a template and modify from there as the new year (2018) budget.

Q Is there an easy way for the system to go through all the accounts and create a blank budget file entry for each account?

Yes, same as the previous question. You should create two budget spreadsheets (a Balance sheet and a Profit and Loss sheet). Please see samples below:

Balance Sheet Budget

Profit And Loss Budget

Q - I understand that each period must be filled in as a plus or minus entry. Is there any automatic way to do that from the account totals at fiscal year-end?

A - There is no automatic way, but the concept is very simple --- the debit balance present by “Plus,” and the credit balance present by “Minus.” Please see previous example.

Q - I don't understand the structure of the file with the revisions. Is there a record per account / revision?

A - Generally speaking, there is a record per account/year/revision.  You are almost correct. You just need to know that the budget for different  years are different records.

Q - For example, if we have only 10 accounts, and I get started with the original version, I assume there would be 10 records in the budget file.

A - Yes, that is correct.  This should be budget revision # 1.

Q - Now, I want to revise the records for revision # 1. Will there be 20 records?

A - You may have two ways to do a revision. (1). Revise under revision # 1. That means you still keep 10 records. (2). Copy revision # 1 to revision number # 2, then revise from revision # 2. Then you will be have 20 records.

Q - What if I wanted to revise only 1 of the original 10 records. Will there be only 11 records on file, or will the original 10 records remain as they were entered, and another 10 records added with the one changed and the other 9 as they were originally?

A - The answer is the same as the previous one.

Q - Sometime in the past 20 years, someone put some data into the budget file. I want to erase all that and start over again. How do I do that?

A - Yes, you may answer “Yes” to Purge Records at print “Edit List.”

Q - I see there's a way to list any accounts. That seems to be the only report in this budget system. Is there anything else available?

A - You may prepare a budget from a CSV file, then import it into the budget file. It will be very easy. Besides the option to “List” a report to a text file, you may export to a CSV file as a spreadsheet report. Export functions have two purposes: (1) to create an Excel format report, or (2) for revising purposes – you may export revision # 1 to a CSV file. Then you can work on the CSV file to make revisions. After you're finished, you can import the file back as revision # 2. Later, the user may decide to compare your financial statement with budget revision # 1 or # 2.


General Ledger

  1. GLMENU General Ledger Package Overview
  2. My General Ledger Interface with Other Package Is Out of Balance
  3. Can Journal Ledger Be Imported to General Ledger?
  4. Is There a Way to Pull All Manual GL Entries Out of Elliott?
  5. How to Print a Wider Financial Statement
  6. General Journal Transaction Out Of Balance After Interface with AR
  7. How to Archive GL Data Before Year-End Closing Procedure
  8. GL Year-End Closing Checklist
  9. Do I Need to Kick My Users Out When Interfacing with Other Packages in GL?
  10. General Journal Transaction In Balance But Not Able to Post
  11. Net Income from Profit & Loss Statement Does Not Match Balance Sheet
  12. Feature - G/L Interface from Other Package Customer/Vendor/Employee Number/Name Default
  13. Error During GL Interface from Other Package and Journal Transaction Is Lost
  14. COMPRESS General Ledger Processing Compress General Ledger TRX File
  15. GLBUDMNT General Ledger Budget File Maintenance
  16. GLCMPMNT General Ledger Comparative File Maintenance
  17. GLCONSOL General Ledger Company Consolidation
  18. GLCTLMNT General Ledger G/L Setup
  19. GLDSTMNT General Ledger Distribution Code File Maintenance
  20. GLENTMNT General Ledger Financial Entity File Maintenance
  21. GLJNLLST General Ledger Journal History Report
  22. GLPRDMNT General Ledger Accounting Period File Maintenance
  23. GLPRDSCN General Ledger Period Account Balance Report
  24. GLRATSCN General Ledger Financial Ratio Report
  25. GLRECALC General Ledger Recalculate Account Balances
  26. GLRECENT General Ledger Recurring Journal Trx Processing
  27. GLSRCMNT General Ledger Source File Maintenance
  28. GLTRIALB General Ledger Trial Balance Report
  29. GLWRKSHT General Ledger Print General Ledger Worksheet
  30. INTERFAC General Ledger Interface From Other Packages
  31. TEXTMNT General Ledger Statement Text File Maintenance
  32. SRCEXREF General Ledger Source Cross Reference Report
  33. YEAREND General Ledger Year-End Procedure
  34. GLACTMNU General Ledger G/L Account File
  35. GNJINLENT General Ledger General Journal Trx Processing
  36. My Net Income (BSNI) at Balance Sheet Does Not Equal My Net Income on the P&L Statement
  37. Budget File Maintenance Questions & Answers
  38. LAYMNU General Ledger Statement Layout File Maintenance 1
  39. LAYMNU General Ledger Statement Layout File Maintenance 2
  40. LAYMNU General Ledger Statement Layout File Maintenance 3
  41. LAYMNU General Ledger Statement Layout File Maintenance 4
  42. LAYMNU General Ledger Statement Layout File Maintenance 5
  43. LAYMNU General Ledger Statement Layout File Maintenance 6
  44. LAYMNU General Ledger Statement Layout File Maintenance 7
  45. LAYMNU General Ledger Statement Layout File Maintenance: Index
  46. STMNTMNU Select and Print Financial Statements 1
  47. STMNTMNU Select and Print Financial Statements 2
  48. STMNTMNU Select and Print Financial Statements 3
  49. STMNTMNU Select and Print Financial Statements 4
  50. STMNTMNU Select and Print Financial Statements: Index
  51. Job Code Adjustment through GL Journal Entries
  52. How to Distribute Sales to General Ledger by Warehouse Location
  53. What Is the Meaning of Leading Two Letters of Journal Source in General Ledger or Distribution?

Feedback and Knowledge Base