highlightingMay 2014 / PhreeBooksR36RC3
Author – Charles
draft

Background Highlighting:

PhreeBooks has recently introduced a feature that visually conveys the SKU’s ‘Inventory Status‘ during data entry using Background Highlighting. This is a time saving feature.

The Background Highlighting is an Alert! for the user (or a ‘take note’).

Sales Orders:
MediumPurple‘ –  not in stock
MediumOrchid‘ –  not in stock but is on-order

Sales/Invoice:
Pink‘ –  inactive and not in-stock  (inactive box checked in SKU details page – reversible)

Purchase Orders:
Orange‘ –  item is in-stock
MediumOrchid‘ –  item is already on-order

Purchase/Receive:
Pink‘ –  inactive stock (has the inactive box checked in SKU details page – reversible)
Aquamarine‘ – there is a Sales Order for this item  (should help when you receive products, so you know what should be sorted as normal stock and what should be set aside for a customer.)

NOTE: If you ‘hover’ your cursor above any of these highlighted SKU fields, you should see explanatory hover-text next to your mouse.

The above features do not take into account the user-defined ‘Minimum Stock Level‘ for each SKU.

Update 23-May-2014
Rene has changed the background-colour oforangelin
MediumOrchid‘ –  not in stock but is on-order to  FF6633 (Orangelin)
This update will be included in the next release of PhreeBooks.

Any comments, queries or suggestions for improvement to the Forum please.

This article describes how to change the default currency in Bizuno.

NOTE: Default currency is selected during install and can only be changed if no journal entries have been made.

  1. Enter the settings for currency: My Business -> Settings -> Bizuno Tab -> PhreeBooks Accounting (Settings Icon) -> Currencies Tab.
  2. The current default currency will be highlighted (or be the only one). Click the New icon to bring a popup window with the currency selections. The list represents most common currencies and will pre-generate the properties for the selected currency. Select a currency and press the Next icon.
  3. A form will appear with the settings for the selected currency. Most of the values will be pre-defined, make any necessary changes.
  4. Select the default check box to make this the new default currency.
  5. Press the Save icon to save the new currency. This action will change the default ISO currency in the system to the new currency and makes all other currencies alternates.
Read More

middlecheck1March 2014 / PhreeBooksR36RC3
Author – Charles (instructions by DP)

Checks are printed on pre-printed three-part check stock (middle check). Have a chat with you bank.

Please make sure that you are happy that the PhreeBooks Form, Bank Check- Three Part, will match your proposed check stock before buying them. Best to print a check to blank A4 (or whatever is most suitable) and ‘try it for size’.

bank check

It is possible to adjust the layout of the Bank Check- Three Part in PhreeForm.

Often a business that prints a lot of checks will have one printer dedicated to printing checks only, loaded with three-part blank check stock. Two parts are sent to the customer and one retained.

Printing a Check:

  • Enter a purchase/receive and fill out the form.
  • VENDORS > Invoices > New Purchase/Receive Inventory
  • Use Add/Update to enter the Pay-To information.
  • You can enter line item(s) without SKUs, just make sure you put a quantity (usually 1), a description and a price.
  • Then press the Payment icon (calculator) and the transaction will be posted and you will be taken to the Payment screen.
  • All the fields should be filled out. Verify the reference number matches the check number.
  • Press the PDF icon and you should get the Form: Bank Check- Three Part popup.
  • Select the correct details and press the PDF icon. You should see the check image in the browser window.
  • Print it as an overlay on a pre-printed three-part check stock (middle check).

Useful Information:

Please post any queries or comments to the Forum

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

Read More