Accounting for WordPress
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:
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:
Sample purchase_orders.txt file:
InvoiceNumber,PostDate,Total,BillContactID,SKU,Qty,LineTotalPO345,12/12/2016,55.00,DIY Bike Co,Wheel-Black,11,55.00PO364,12/14/2016,45.00,Tony’s Tires,Wheel-Black,4,20.00PO364,12/14/2016,45.00,Tony’s Tires,Tire-Knobby,1,25.00
Sample accounts_payables.txt file:
Sample sales_orders.txt file:
InvoiceNumber,PostDate,Shipping,Total,BillContactID,ShipContactID,SKU,Qty,LineTotal3423,12/20/2016,10.00,110.00,Jim Taylor,Jim Taylor,Wheel-Black,2,100.003427,12/21/2016,25.00,275.00,Dave Jones,Dave Jones,Wheel-Black,4,200.003427,12/21/2016,25.00,275.00,Dave Jones,Dave Jones,Tire-Knobby,1,50.00
Sample accounts_receivables.txt file:
Powered by BetterDocs
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.