-
Client Resources
-
EBMS Main Documentation
- Introduction
- Getting Started
- Getting Started | Initial Installation
- Getting Started | Company Setup
- Quick User Guide | Financial Staff | Accountant
- Quick User Guide | Financial Staff | Accountant | Accountants Journal
- Quick User Guide | Sales Staff
- Quick User Guide | General Staff
- Features
- Reports
- Reports | Excel Add-In
- Reports | Excel Add-In | Troubleshooting
- Security
- Server Manager
- Technical
- Technical | Data Import and Export Utility
- Technical | SQL Mirror
- Automotive
- Automotive | Parts Catalog
- Automotive | Pricing
- Automotive | Point of Sale
- Automotive | Product Application
- Automotive | Keystone Interface
- Metal Supply
- Fuel Sales
- Horticulture
- Horticulture | Farm Setup
- Horticulture | Processing Payroll
- Horticulture | Managing the Farm
-
Sales
- Introduction
- Customers
- Customers | Miscellaneous Customers
- Proposals
- Proposals | Processing Proposals
- Proposals | Sets and Templates
- MyProposals
- MyOrders
- Sales Orders
- Invoices
- Materials Lists
- Sales and Use Tax
- Sales and Use Tax | TaxJar
- CRM
- CRM | Auto Send
- Recurring Billing
- Credits
- Customer Payments
- Payment Card Processing
- Payment Card Processing | Gift Cards
- Payment Card Processing | Loyalty Cards
- Payment Card Processing | Verifone Gateway
- Freight and Shipping Tools
- General Ledger Transactions
- Point of Sale
- Point of Sale | Point of Sale Hardware
- Point of Sale | Xpress POS System
- Point of Sale | Advanced Tools
- Signature Capture
- Salesperson Commissions
-
Inventory
- Product Catalog
- Product Catalog | Using Product Codes for No Count Items
- Product Pricing
- Product Pricing | Special Pricing
- Tracking Counts
- Unit of Measure
- Purchasing
- Special Orders and Drop Shipped Items
- Receiving Product
- Barcodes
- MyInventory and Scanner
- Components (BOM) and Accessories
- Components (BOM) and Accessories | Component Formula Tool
- Made-to-Order Kitting
- Configure-to-Order Kitting
- Multiple Inventory Locations
- Multiple Inventory Locations | Creating Locations
- Multiple Inventory Locations | Using Multiple Locations
- Multiple Inventory Locations | Product Catalog Sync
- Multi-Vendor Catalog
- Serialized Items
- Serialized Items | Purchasing or Manufacturing an Item
- Serialized Items | Selling and/or Associating an item with a customer
- Lots
- Product Attributes
- Product Attributes | Selling and Purchasing Items with Attributes
- Product Attributes | Custom Attributes
- Mobile Scanner (Legacy)
-
Labor
- Getting Started
- Workers
- Taxes and Deductions
- Work Codes
- Time and Attendance
- Time and Attendance | Time Track App
- Processing Payroll
- Closing the Payroll Year
- Processing Payroll - Advanced
- Salaried Pay
- Piecework Pay
- Direct Deposit
- 3rd Party Payroll Service
- Subcontract Workers
- Flag Pay
- Prevailing Wages
- MyDispatch
- MyTasks
- MyTime
- MyTime | Communications
- MyTime | Setup
- Tasks
- Tasks | Getting Started
- Tasks | Creating Tasks
- Tasks | Scheduling Tasks
- Tasks | Customizing Task Views
- Tasks | Managing Tasks
-
Financials
- Introduction
- Fiscal Year
- Chart of Accounts
- Budget
- Financial Reporting
- Transactions and Journals
- Transactions and Journals | Journals
- Account Reconciliation
- 1099
- Departments and Profit Centers
- Fund Accounts
- Bank Accounts
- Bank Feed
- Vendors
- Vendors | Miscellaneous Vendors
- Purchase Orders
- Expense Invoices
- Vendor Payments
- AP Transactions
- Landed Cost
- Fixed Assets and Depreciation
- Fixed Assets and Depreciation | Fixed Assets
- Fixed Assets and Depreciation | Fixed Assets | Adding Assets
- Fixed Assets and Depreciation | Processing Depreciation
- Fixed Assets and Depreciation | Disposing Assets
- MyJobs
-
E-commerce
-
Rental
-
Job Costing
-
Manufacturing
Connecting the Budget to a Spreadsheet
How to import budget values from an Excel file
Many financial managers are accustomed to generating a budget using a spreadsheet. EBMS allows the user to import budget values into the EBMS budget directly from a MS Excel spreadsheet. Combining this import option with the ability to read EBMS from MS Excel allows the manager to calculate almost any type of budget without manually transferring values.
Complete the following steps to import data from MS Excel to the EBMS budget:
- Create budget values within a spreadsheet as shown below:
- It is recommended to create a clearly named sheet (labeled Totals in the example shown below) that contains the totals that will be passed to the budget within EBMS. Since EBMS addresses the spreadsheet cells by column and row numbers, this step will assist in maintaining the exact location. Notice that the budget calculations are done within the Budget tab of the spreadsheet example shown below:
- Close the spreadsheet and open the budget list by going to Financials > Budget from the main EBMS menu.
- Open a specific account by double clicking on the account line. This will open a Budget dialog for that account as shown below:
- Select the Excel Sheet formula from the Total Calculation option list as shown below. (Review the Calculating a Budget Using a Formula section for more details on this and other calculation options.)
- The Excel formula template requires the following 4 references within the Excel spreadsheet:
- The Excel Sheet name which is found at the bottom of the Excel spreadsheet. (The first sheet in the sample spreadsheet shown above is named Totals.)
- Enter the Cell reference code. This code must be a simple column letter + row number combination such as A1, B5, etc.
- Enter the File name. Note that the full location path of the file must be entered, including the file path and file extension.
- Click on the Calculate button to test the connection. The Total Calculation template entries will not check for file and sheet entry errors or invalid row or column values.
Repeat these steps for each value that you wish to copy from the spreadsheet to the EBMS budget list. Use the Change by G/L Code wizard from the budget list dialog to set the Excel formula for a range of accounts. Enter the sheet and file settings for the entire range and then change the individual row and column values for each account. Review the Change a Range of Budget Accounts section for details for changing information for a range of accounts.