Changes

Jump to: navigation, search

QuickBooks Journal Entries

831 bytes removed, 15:43, 22 February 2014
no edit summary
Upon exporting your fulfilled Sales Order, an Invoice will be created in QuickBooks for the Sales Order. (The following information is given for a fulfilled Sales Order that ''has not'' been already paid for in Fishbowl) A '''Sales Adjustment''' (showing your total sale) will be credited, and a debit made to your '''Accounts Receivable''' will offset your Sales adjustment. Your '''Inventory Asset''' will credit, and will be offset by a debit to the '''Cost of Goods Sold'''. Please see the following image:
[[File:Completing a sales order.JPG|Image:Completing_a_sales_order.JPG]]
The following QuickBooks '''Transaction Detail by Account''' report shows the debit and credit accounts affected when the Fulfilled Sales Order is exported from Fishbowl:
[[File:Transaction Detail by Account SO not paid.JPG|Image:Transaction_Detail_by_Account_SO_not_paid.JPG]]
The following image provides an Invoice from QuickBooks showing Standard Inventory Items. The report has been customized to show the Number and UOM of the product.
[[File:SO QB Invoice.JPG|Image:SO_QB_Invoice.JPG]]
The following General Journal Entry from QuickBooks shows the debit and credit accounts affected when a Sales Order is exported from Fishbowl that ''has not'' been paid for in Fishbowl.
The following information is now given for a fulfilled Sales Order that ''has'' been paid for in full in Fishbowl prior to exporting to QuickBooks. Upon exporting your fulfilled Sales Order, a Sales Receipt will be created in QuickBooks for the Sales Order. A '''Sales Adjustment''' (showing your total sale) will be credited, and a debit made to your '''Undeposited Funds''' will offset your Sales adjustment. Your '''Inventory Asset''' will credit, and will be offset by a debit to the '''Cost of Goods Sold'''. Please see the following image:
[[File:Fulfilling a SO paid for in FB.JPG|Image:Fulfilling_a_SO_paid_for_in_FB.JPG]]
The following QuickBooks '''Transaction Detail by Account''' report shows the debit and credit accounts affected when the Fulfilled Sales Order is exported from Fishbowl:
[[File:Transaction Detail by Account paid SO.JPG|Image:Transaction_Detail_by_Account_paid_SO.JPG]]
The following image provides a Sales Receipt from QuickBooks showing Standard Inventory Items that have previously been paid for in Fishbowl.
Upon exporting your Sales Order (containing a Service Item) from Fishbowl, an Invoice will be created in QuickBooks. Your Service item will affect QuickBooks accounts in the following ways: A credit will be made to the Sales Retail account, and is offset by a Debit made to the Accounts Receivable. Please note the following image:
[[File:T chart Service items.JPG|Image:T_chart_Service_items.JPG]]
The following QuickBooks '''Transaction Detail by Account''' report shows the debit and credit accounts affected when a Sales Order with a service item is exported from Fishbowl.
As seen below, Sales Order #15 had 1 service item described as a Paint Job. A credit was made to the Sales Retail account with an offset debit made to the Accounts Receivable.
[[File:TDBA service item.JPG|Image:TDBA_service_item.JPG]]
The following image provides an Invoice view of this service item. The report has been customized to show the Number and UOM of the product.
[[File:QB Invoice Service items.JPG|Image:QB_Invoice_Service_items.JPG]]
=== Discount Items ===
Upon exporting your Sales Order (containing a Discount Item) from Fishbowl, an Invoice will be created in QuickBooks. Your Discount item will affect QuickBooks accounts in the following ways: A credit will be made to the '''Sales Retail''' account, while a debit is made to the '''Discount Expense''' account. Please note the following image:
[[File:T chart discount items.JPG|Image:T_chart_discount_items.JPG]]
The QuickBooks '''Transaction Detail by Account''' report shows the debit and credit accounts affected when a Sales Order with a discount item is exported from Fishbowl.
Upon exporting your credit return Sales Order from Fishbowl, a Credit Memo will be created in QuickBooks. Your credit return will affect QuickBooks accounts in the following ways: A credit will be made to the Accounts Receivable and Cost of Goods Sold accounts, while a debit is made to the Inventory Asset and Sales Retail accounts. Please note the following image:
[[File:T chart credit return.JPG|Image:T_chart_Service_items.JPG]]
The QuickBooks '''Transaction Detail by Account''' report shows the debit and credit accounts affected when a credit return Sales Order is exported from Fishbowl.
As seen below, Sales Order #50039 had a credit return item listed. A credit was made to '''Accounts Payable and Cost of Goods Sold accounts,''' with Debits made to the '''Inventory Asset, and Sales Retail''' accounts.
[[File:TDBA credit return.JPG|Image:TDBA_service_item.JPG]]
The following image provides a Credit Memo view of this credit return.
[[File:Credit Memo credit return.JPG|Image:QB_Invoice_Service_items.JPG]]
=== Drop Shipping ===
Upon exporting your Sales Order (with a drop shipped item) from Fishbowl, both a Bill and Invoice will be created in QuickBooks. An Invoice will be created for the Sales Order, while a Bill will be created for the Purchase Order. When drop shipping an item, you must first place the item on a Sales Order. After issuing the Sales Order, a Purchase Order will automatically be created for your vendor. Upon Receiving your Purchase Order, your Sales Order will also auto-fulfill. You may then export to QuickBooks to have both a Bill and Invoice created. Your drop shipped order will affect QuickBooks accounts in the following ways: A credit will be made to the '''Accounts Receivable and Cost of Goods Sold accounts''', while a debit is made to the '''Inventory Asset and Sales Retail accounts'''. Please note the following image:
[[File:T chart drop ship.JPG|Image:T_chart_Service_items.JPG]]
The QuickBooks '''Transaction Detail by Account''' report shows the debit and credit accounts affected when an item is drop shipped and exported from Fishbowl.
As seen below, Sales Order #50041 and Purchase Order #10034 were fulfilled in Fishbowl. Credits were made to '''Accounts Payable and Sales Retail,''' with Debits made to the '''Accounts Receivable and Cost of Goods Sold''' accounts.
[[File:TDBA drop ship.JPG|Image:TDBA_service_item.JPG]]
The following images provide both a Bill and Invoice view of the drop shipped item.
[[File:Invoice drop ship.JPG|Image:QB_Invoice_Service_items.JPG]]
[[File:Bill drop ship.JPG]]
Upon exporting your Sales Order (containing a Misc Item) from Fishbowl, an Invoice will be created in QuickBooks. Your Misc item will affect QuickBooks accounts in the following ways: A credit will be made to the '''Sales Retail''' account, and is offset by a Debit made to the '''Accounts Receivable'''. Please note the following image:
[[File:T_chart_misc_sale.JPG|Image:T_chart_Service_items.JPG]]
The following QuickBooks '''Transaction Detail by Account''' report shows the debit and credit accounts affected when a Sales Order with a service item is exported from Fishbowl.
As seen below, Sales Order #50040 had a misc item described as a Clearance Item. A credit was made to the '''Sales Retail''' account with an offset debit made to the '''Accounts Receivable'''.
[[File:TDBA_misc_sale.JPG|Image:TDBA_service_item.JPG]]
The following image provides an Invoice view of this misc sale. The report has been customized to show the Number and UOM of the product.
[[File:Invoice_misc_sale.JPG|Image:QB_Invoice_Service_items.JPG]]
=== Standard Shipping ===
Upon exporting your fulfilled Sales Order, an Invoice will be created in QuickBooks for the Sales Order. (The following information is given for a fulfilled Sales Order that has ''not'' been already paid for in Fishbowl). Your '''Sales Retail''', '''Inventory Asset''', and '''Shipping Income''' will all be credited. To offset the Credits made, the '''Accounts Receivable''' and '''Cost of Goods Sold''' will be debited. Please see the following image:
[[File:Fulfilling a sales order with a shipping line item.JPG|Image:Fulfilling_a_sales_order_with_a_shipping_line_item.JPG]]
The following QuickBooks '''Transaction Detail by Account''' report shows the debit and credit accounts affected when the Fulfilled Sales Order is exported from Fishbowl:
Sales Order #7 had a total of 2 inventory items and 1 shipping line item. This order was made for the customer All About Bikes.
[[File:SO with shipping item transaction detail by account.JPG|Image:SO_with_shipping_item_transaction_detail_by_account.JPG]]
The following image provides an Invoice view of this Shipping item:
Upon exporting your Sales Order with Carton Based Shipping from Fishbowl, an Invoice will be created in QuickBooks. Carton Based Shipping will affect QuickBooks accounts in the following ways: A credit will be made to the '''Shipping Accrual''' and '''Shipping Income''' accounts, while a debit is made to the '''Accounts Receivable''' and '''Cost of Goods Sold''' accounts. Please note the following image:
[[File:T_chart_carton_based_shipping.JPG|Image:T_chart_Service_items.JPG]]
The following QuickBooks '''Transaction Detail by Account''' report shows the debit and credit accounts affected when a Sales Order with Carton Based Shipping is exported from Fishbowl.
As seen below, Sales Order #50038 has a debit to the '''Accounts Receivable''' and '''Cost of Goods Sold''' account, with a credit made to the '''Shipping Accrual''' and '''Shipping Income''' accounts.
[[File:TDBA_carton_based_shipping.JPG|Image:TDBA_service_item.JPG]]
The following image provides an Invoice view of this order. The report has been customized to show the Number and UOM of the product.
[[File:Invoice_carton_based_shipping.JPG|Image:QB_Invoice_Service_items.JPG]]
=== Handling prepayments ===

Navigation menu