Our Consulting Services
We offer complete QuickBooks Enterprise Consulting in Fort Worth and Dallas. Setup, Conversion, Data Import, Troubleshooting and Support.
QuickBooks Enterprise Setup
It is essential that a new QuickBooks setup be correct or you may have many problems later. It is much more cost efficient to spend a little money upfront and have it correct from the beginning.
A new QuickBooks company file can be imported from a variety of database formats including Excel, CSV, Access and ODBC. We can import your data directly into a new QuickBooks company file. You may have thousands of customers, vendors and inventory items to import. No need to hand key!
What does a QuickBooks Setup include?
- Software Installation
- Fine-tuning your company preferences
- Transfer of your Company file from older QuickBooks Versions or other software
- Importing kits and assemblies with all component items including nested assembly items.
- Importing Customer and Vendor lists from other software such as Excel
- We can import Estimates, Sales Orders, Purchase Orders and Invoices with line item detail.
- Setting up your Chart of Accounts and Financial Reports
- Setting up your Bank and Credit Card Accounts
- Creating your list of products and services for invoicing
Ledger Consulting is Your QuickBooks Support Department providing Training, Troubleshooting, Ongoing Support and more
What can be Imported in QuickBooks?
Here are some examples of what can be imported during a QuickBooks Setup:
Chart of Accounts: Your company asset, liability, equity, income and expense accounts including beginning balances
Customer Information: complete address & contact information, a ship to address, terms, prices levels, sales tax information, sales reps, credit limits, notes, outstanding balances and more!
Vendor Information: complete address & contact information, terms, 1099 tax information, credit limits, notes, outstanding balances and more!
You may have thousands of customers, vendors and inventory items. We can import them. No need to hand key!
Inventory Items, Kits & Assemblies: Do you have several thousand inventory parts, kits, assemblies and subassemblies in your build of materials? These can be imported. Some of these groups and subassemblies may have dozens of component parts. First, we import all the individual component parts, then the subassemblies with all the individual component parts included in the build of materials and finally the main assemblies. Each item can be assigned individually to an inventory, sales and cost of goods sold account. WIP accounts can also be used.
Inventory imports can also include:
- If an item is taxable
- Preferred Supplier
- Reorder points
- Manufacturer part number
- Bar Code Information
- Units of Measure
Inventory Adjustments: Inventory quantity and values can be imported for each item including warehouse and bin locations.
Accounts Payable: Outstanding bills can be imported with line item detail including due dates, terms and memos. Vendor credits and partial payments can be included. Inventory received without a bill can also be imported.
Accounts Receivable: Outstanding invoices with line item detail can be imported, including due dates, terms, customer credits, sales tax, sales rep, purchase order or sales order reference number, memo, warehouse / bin location and more!
Bank and Credit Card Detail: This can include bank transactions such as checks, deposits as well as credit card accounts.
Other Forms: Also available for importing are Estimates, Purchase Orders and Sales Orders with line item detail.
Have some custom information you need in QuickBooks such as product color? We can import custom fields!
We can perform a monthly, quarterly or annual review of your QuickBooks file. If proper procedures are not being followed, many problems can occur such as accounts out of balance, negative balances, inventory not tying to the balance sheet, negative inventory balances and many other issues. We use a checklist during our review. A review can be remote or at your location.
We can also work with your CPA to gather required year-end reports and research questions for the annual tax return.
QuickBooks Enterprise Support
Need onsite QuickBooks Support? Every business has some infrequent or unusual situations occur. When these happen, you may need support. Typical support situations include:
|Bank Accounts Not Reconciling|
|Paid Bills or Invoices still showing as Unpaid|
|Handling Returns and Discounts|
|Inventory Count is off|
|Handling Customer or Vendor Prepayments|
|Entering Bounced Checks|
|Balance Sheet Issues|
|Many other situations.|
Troubleshooting and Cleanup
We offer a variety of QuickBooks Troubleshooting and cleanup services, such as:
|Reconciling Accounts never reconciled|
|Fixing negative balances on the P&L and Balance Sheet|
|Researching Prior YE Retained Earnings out of Balance|
|Resolving Negative Inventory|
|Fixing Inventory Sales Items Mapped to an Incorrect Account|
|Fixing Paid-off Loan Balances still showing on the balance sheet|
|Entering Year End Journal Entries from you CPA|
|Many other situations as needed.|
Business Planning with QuickBooks
QuickBooks offers a wide variety of reports to analyze your business. Here is a partial list:
- Create as many budgets as needed for your company. Budgets can for your entire company, each department and even each project!
- Create an entire Business Plan that can be used for SBA loans or for internal planning purposes.
- Cash Flow Reports can help you plan your purchases and cash disbursements
- Reports to show profitability by inventory item so you can see which items are most profitable and which items should be discontinued.
- Many third party addon packages can greatly extend the functionality
QuickBooks Enterprise Consulting in Fort Worth and Dallas
We offer Complete QuickBooks Consulting for your business. Call us today!
Interested in Learning More? Call Today to Schedule an Appointment with a Certified QuickBooks ProAdvisor
We provide both local and remote support.