Biz School

Created with Sketch.

How can we help?

  1. Welcome to Bizuno-U
  2. FAQs
  3. Quick Start
    1. Installation
    2. Configuration
    3. Your Dashboards
    4. Your First Product
    5. Your First Purchase
    6. Your First Sale
  4. Working With Bizuno
    1. Navigation
    2. Dashboards
    3. Currencies
    4. Locale
    5. Settings
  5. Users Guide
    1. Customers
      1. Manager
      2. CRM Manager
        1. Promotion Manager
      3. Sales Manager
        1. Request for Quote
        2. Sales Order
        3. Sale
        4. Credit Memo
      4. Prices
      5. Amazon Interface
      6. Order Fulfillment
      7. Returns Manager
      8. Reports and Forms
    2. Vendors
      1. Manager
      2. Purchases
        1. Request for Quote
        2. Purchase Order
        3. Purchase
        4. Vendor Credit Memo
      3. Prices
      4. Reports and Forms
    3. Inventory
      1. Manager
        1. Accessories
        2. Attributes
        3. Images
        4. Options
        5. Vendors
      2. Assemblies
      3. Adjustments
      4. Build Manager
      5. Inventory Bulk Edit
      6. Receiving/Inspection
      7. Reports
    4. Banking
      1. Customer Receipts
      2. Customer Refunds
      3. Vendor Payments
      4. Vendor Payments - Bulk
      5. Vendor Refunds
      6. Account Register
      7. Cash Reconciliation
      8. Reports and Forms
    5. General Ledger
      1. GL Manager
        1. Intuit Online Payroll
      2. Budgeting
      3. Reports and Forms
    6. Quality
      1. Document Control
      2. Quality Manager
      3. Maintenance Manager
    7. Tools
      1. Shipping Manager
      2. PhreeForm - Reports/Forms
      3. OpenCart Interface
      4. PrestaShop Interface
      5. WooCommerce Interface
      6. Google Interface
      7. Image Manager
      8. Translator Assistant
      9. Import/Export
      10. Backup/Restore
    8. My Business
      1. Profiles
      2. Employees
      3. Fixed Assets Manager
  6. Administrators Guide
    1. Module Settings
      1. Bizuno Settings
        1. Linking Your PhreeSoft.com Account
        2. SMTP Configuration
        3. Creating a New Store
      2. Contacts Settings
      3. Inventory Settings
      4. Payment Settings
      5. PhreeBooks Settings
      6. PhreeForm Settings
    2. Extension Settings
      1. Multi-Store Extension
      2. Service Builder - Job Templates
    3. Security
      1. Data Encryption
    4. Roles
    5. Users
    6. Maintenance
      1. Protecting Your Business Data
      2. Backing Up Your Data
      3. Restoring From a Backup
    7. Reloading and Importing Reports and Forms
    8. Using Barcode Scanners
    9. Importing and Exporting
      1. Importing Contacts – Customers and Vendors
      2. Converting from Another App
      3. Converting from PhreeBooks
  7. Advanced Topics
    1. Working With Taxes
    2. Fixing Trail Balance is Out of Balance Errors
    3. Editing Reports and Forms
    4. Entering a Vendor Deposit
    5. Entering a Customer Deposit
  8. Tutorials
    1. Mastering Price Sheets
    2. Translating Bizuno
  9. Technical Stuff
    1. Developer Information
    2. Bizuno API
    3. Adding New Themes
  10. More Resources
    1. Glossary
  11. Confirm Shipments
  12. Downloading Orders
  13. Reconciling Payments
  14. Uploading Inventory

Converting from Another App #

Converting from Another Accounting Program (Line in the Sand)

One way to convert from your existing accounting software package to Bizuno is called the ‘Line in the Sand’ approach. This article describes the process that needs to be followed to implement this approach. This method is best used at end of fiscal year.  The basic process is:

  1. Verify your chart of accounts in Bizuno matches that from your current application.
  2. Import contacts (Tools -> Import/Export -> Contact Tab). This should be completed well before the conversion day. A template is available on the Contacts import tab to help format the input data and includes field names and descriptions.
  3. Import Inventory (Tools -> Import/Export -> Inventory Tab). This should also be completed well before the conversion day. A template is available on the Inventory import tab to help format the input data.
  4. Build Inventory, Accounts Payable and Accounts Receivable files (see examples below). These files are minimized so they may be generated by hand quickly (if necessary) are output directly from your current application.
  5. Print trial balance from your current application to a PDF file or paper for use old guys.
  6. Backup Bizuno (Tools -> Business Backup -> Business Backup section -> Go icon), just in case. This is just for precaution as your new values will have precedent.
  7. Purge the general ledger (Settings -> PhreeBooks -> Tools -> Purge Journal Entries).
  8. Enter Beginning Balances using the data from your Trial Balance printed from above. Save. This will take a while as the information needs to roll through each gl account for all months in your fiscal calendar.
  9. Print Trial Balance in Bizuno (Tools -> Reports/Forms -> General Ledger -> Reports -> GL Trial Balance -> Open (get a popup) -> PDF icon). At this point your balance sheet and income statement will not match that form your prior application. This is because these entries are BEFORE the current fiscal year. All accounts that are closed at the end of the fiscal year will be closed and the balances will be rolled into your retained earnings account. You will need this report for making adjustments later in this procedure.
  10. Import inventory valuation (Tools -> Import/Export -> PhreeBooks Tab -> Inventory, select file and press Import icon)
  11. Import purchase orders (Tools -> Import/Export -> PhreeBooks Tab -> Purchase Orders, select file and press Import icon)
  12. Import accounts payables (Tools -> Import/Export -> PhreeBooks Tab -> Accounts Payable, select file and press Import icon)
  13. Import sales orders (Tools -> Import/Export -> PhreeBooks Tab -> Sales Orders, select file and press Import icon)
  14. Import accounts receivables (Tools -> Import/Export -> PhreeBooks Tab -> Accounts Receivable, select file and press Import icon)
  15. Print another Trial Balance in Bizuno. This is where the paper part is best.
  16. Edit your beginning balances and subtract the AP total from your import file from the accounts payable account (to bring it back to your original beginning balance), subtract your AR total from your import file from your accounts receivable account, take the GL account you used as your holding account and add back the payables total and subtract the AR totals from your import file. This should restore all three accounts to the values you had BEFORE the import (step 7). Verify your inventory stock balances to make sure the import was successful.

This is a good time to check you AP/AR accounts as the value after step 8 should be equal to the total of your import for each type. If they are off (as they usually are) you will need to make a general journal entry to get them back to being even.

This process only works when converting at year end as the expenses, sales accounts are zeroed out at the start of each fiscal year. For this reason, you will see no expenses OR sales as they will be rolled into your retained earnings account. This is because beginning balances are the values ‘entering’ the fiscal year.

A mid year line in the sand conversion will require additional steps. Generally, you will need to post a GL entry restating your activity year to date that is posted to any account that is closed at year end, (sales, expenses, etc.). Create or use a holding account that you can balance against when adjusting your beginning balance to compensate for the duplicate values. After this process, your balance sheet and income statement from your prior accounting application should match exactly with the like Bizuno financial statements.

I think you should try a few dry runs before the big day. You can always purge the GL and start over. This way when the day comes, you’ll get it done in under an hour.

Sample inventory.txt file:

SKU,Qty,Total
Tire-Balloon,5,10.00
ANewSKU,2,13.00

Sample purchase_orders.txt file:

InvoiceNumber,PostDate,Total,BillContactID,SKU,Qty,LineTotal
PO345,12/12/2016,55.00,DIY Bike Co,Wheel-Black,11,55.00
PO364,12/14/2016,45.00,Tony’s Tires,Wheel-Black,4,20.00
PO364,12/14/2016,45.00,Tony’s Tires,Tire-Knobby,1,25.00

Sample accounts_payables.txt file:

InvoiceNumber,PONumber,PostDate,Total,BillContactID,HoldingGLAccount
GD20161222,PO-Dave,12/22/2016,66.00,goDaddy.com,3800

Sample sales_orders.txt file:

InvoiceNumber,PostDate,Shipping,Total,BillContactID,ShipContactID,SKU,Qty,LineTotal
3423,12/20/2016,10.00,110.00,Jim Taylor,Jim Taylor,Wheel-Black,2,100.00
3427,12/21/2016,25.00,275.00,Dave Jones,Dave Jones,Wheel-Black,4,200.00
3427,12/21/2016,25.00,275.00,Dave Jones,Dave Jones,Tire-Knobby,1,50.00

Sample accounts_receivables.txt file:

InvoiceNumber,PONumber,PostDate,Total,BillContactID,HoldingGLAccount
20322,,12/22/2016,175.00,New Guy,3800

Help Guide Powered by Documentor
Suggest Edit