Changes

Jump to: navigation, search

QuickBooks Journal Entries

7,181 bytes removed, 16:25, 16 March 2017
no edit summary
== Import/Export {{top}} ==
=== Company Information === The following table shows the Company Information that is imported into Fishbowl from QuickBooks by using the Accounting Configuration Wizard. At this time, multiple addresses will not IMPORT into Fishbowl; however, if multiple Company addresses have been entered into Fishbowl they will EXPORT to QuickBooks. {| class="prettytable"|-! QuickBooks! <center>Imports To</center>! Fishbowl! Max Characters|-| Company Name| {{Arrow|Right}}| Name| 60|-| Address| {{Arrow|Right}}| Default Address| Line = 90<br>Zip = 10<br>City = 30<br>State = 30<br>State Abbr = 10<br>Country Name = 64<br>Country Abbr = 10|-| Phone| {{Arrow|Right}}| Phone| 64|-| Fax| {{Arrow|Right}}| Fax| 64|-| E-mail| {{Arrow|Right}}| E-mail| 64|-| Web Site| {{Arrow|Right}}| Web Site| 64|} === Customer === When a customer is created in Fishbowl, it will be exported to QuickBooks for the first time only after an order has been fulfilled and exported to QuickBooks. Aside from the Customer Name (which is required), all of the below information will be exported to QuickBooks only if it is applicable: {| class="prettytable"|-! Fishbowl! <center>Exports To</center>! QuickBooks! Max Characters|-| Name| {{Arrow|Both}}| Customer Name| 60|-| Main| {{Arrow|Both}}| Phone| 64|-| Fax| {{Arrow|Both}}| Fax| 64|-| Email| {{Arrow|Both}}| E-mail| 64|-| Other| {{Arrow|Both}}| Alt. Phone| 64|-| Default Address| {{Arrow|Both}}| Main Address| Line = 90<br>Zip = 10<br>City = 30<br>State = 30<br>State Abbr = 10<br>Country Name = 64<br>Country Abbr = 10|-| Bill To| {{Arrow|Both}}| Bill To| Line = 90<br>Zip = 10<br>City = 30<br>State = 30<br>State Abbr = 10<br>Country Name = 64<br>Country Abbr = 10|-| Ship To| {{Arrow|Left}}| Ship To| Line = 90<br>Zip = 10<br>City = 30<br>State = 30<br>State Abbr = 10<br>Country Name = 64<br>Country Abbr = 10|-| Shipping Terms| <center><div style="font-size: 20px;"></div></center>|||-| Salesperson| {{Arrow|Both}}| Rep| 15|-| Tax Rate| {{Arrow|Both}}| Tax Code| 31|-| Resale Number| {{Arrow|Both}}| Tax Exempt Number| 30|-| Credit Limit| {{Arrow|Both}}| Credit Limit| 12|} === Vendor === When a vendor is created in Fishbowl, it will be exported to QuickBooks for the first time only after an order has been fulfilled and exported to QuickBooks. Aside from the Vendor Name (which is required), all of the below information will be exported to QuickBooks only if it is applicable: {| class="prettytable"|-! Fishbowl! <center>Exports To</center>! QuickBooks! Max Characters|-| Name| {{Arrow|Both}}| Vendor Name| 60|-| Main| {{Arrow|Left}}| Phone| 64|-| Fax| {{Arrow|Left}}| Fax| 64|-| Email| {{Arrow|Left}}| E-mail| 64|-| Other| {{Arrow|Left}}| Alt. Phone| 64|-| Default Address| {{Arrow|Both}}| Main Address| Line = 90<br>Zip = 10<br>City = 30<br>State = 30<br>State Abbr = 10<br>Country Name = 64<br>Country Abbr = 10|} === Item List === The table below shows how Fishbowl [[QuickBooks#Import|imports]] from the QuickBooks item list. {| class="prettytable"|-! QuickBooks! <center>Imports to</center>! Fishbowl|-| Service| {{Arrow|Right}}| [[Part#Part_types|Service type part]]|-| Inventory Part| {{Arrow|Right}}| For more details, see [[#Inventory Part|Inventory Part]]|-| Inventory Assembly| {{Arrow|Right}}| {{Module|Bill of Materials}}|-| Non-inventory Part| {{Arrow|Right}}| [[Part#Part_types|Non-Inventory type part]]|-| Other Charge| {{Arrow|Right}}| [[Part#Part_types|Service type part]]|-| Subtotal| {{Arrow|Right}}| Not imported|-| Group| {{Arrow|Right}}| [[Kitting|Kit type product]]|-| Discount| {{Arrow|Right}}| {{Module|Discount}}|-| Payment| {{Arrow|Right}}| Not imported|-| Sales Tax Item| {{Arrow|Right}}| {{Module|Tax Rate}}|-| Sales Tax Group| {{Arrow|Right}}| {{Module|Tax Rate}}|} === Inventory Part === Inventory parts will be [[QuickBooks#Import|imported]] from QuickBooks when selecting the '''Items''' import. Instead of exporting parts to QuickBooks, Fishbowl uses FB_Item. For other item types, see [[#Item List|Item List]]. {| class="prettytable"|-! QuickBooks! <center>Imports to</center>! Fishbowl|-| Item Name/Number| {{Arrow|Right}}| [[Part#General_tab|Part Number]] and [[Product#General_tab|Product Number]]|-| Preferred Vendor and Manufacturer's Part Number| {{Arrow|Right}}| {{ModuleTab|Part|Vendors}}|-| Unit of Measure| {{Arrow|Right}}| {{ModuleTab|Part|General}}|-| Description on Purchase Transactions| {{Arrow|Right}}| [[Part#General_tab|Part Description]]|-| Description on Sales Transactions| {{Arrow|Right}}| [[Product#General_tab|Product Description]]|-| Sales Price| {{Arrow|Right}}| [[Product#General_tab|Product Price]]|-| On Hand and Average Cost| {{Arrow|Right}}| {{Module|Inventory}}|-| Income Account| {{Arrow|Right}}| {{ModuleTab|Product|Details}}|-| COGS and Asset Account| {{Arrow|Right}}| {{ModuleTab|Part|Accounts}}|-| Reorder Point| {{Arrow|Right}}| {{ModuleTab|Inventory|Part}}|} === Sales Order/Invoice/Credit Memo === {| class="prettytable"|-! Fishbowl! <center>Exports&nbsp;To</center>! QuickBooks|-| Customer| {{Arrow|Right}}| Customer|-| Class| {{Arrow|Right}}| Class|-| Bill To| {{Arrow|Right}}| Bill To|-| Ship To| {{Arrow|Right}}| Ship To|-| Customer PO| {{Arrow|Right}}| P.O. Number|-| Payment Terms| {{Arrow|Right}}| Terms|-| Carrier| {{Arrow|Right}}| Via|-| FOB| {{Arrow|Right}}| F.O.B.|-| Qty| {{Arrow|Right}}| Quantity|-| Product Number &amp; Description| {{Arrow|Right}}| Description|-| Price| {{Arrow|Right}}| Price Each|-| Tax| {{Arrow|Right}}| Tax|-| Fishbowl Sales Order Number| {{Arrow|Right}}| Memo|-| '''Other Options via Tools-Module Options'''| | |-| Tracking Information| {{Arrow|Right}}| Description|-| Optional (Number, Description, UOM Full Name, or UOM Abbreviation)| {{Arrow|Right}}| Other 1 (customized in QuickBooks)|-| Optional (Number, Description, UOM Full Name, or UOM Abbreviation)| {{Arrow|Right}}| Other 2 (customized in QuickBooks)|-| SO Item Note| {{Arrow|Right}}| Description|-| Fishbowl Sales Order Number| {{Arrow|Right}}| QuickBooks Invoice Number|} === Purchase Order/Bill === {| class="prettytable"|-! Fishbowl! <center>Exports To</center>! QuickBooks|-| Vendor| {{Arrow|Right}}| Vendor|-| Main Office| {{Arrow|Right}}| Address|-| Payment Terms| {{Arrow|Right}}| Terms|-| Fishbowl Purchase Order Number| {{Arrow|Right}}| Memo|-| Part Number and Description| {{Arrow|Right}}| Description|-| Qty| {{Arrow|Right}}| Qty|-| Class| {{Arrow|Right}}| Class|} === Journal Entries === {| class="prettytable"|-! Fishbowl! <center>Exports To</center>! QuickBooks|-| Part| {{Arrow|Right}}| Memo|-| Description| {{Arrow|Right}}| Memo|-| Customer/Job| {{Arrow|Right}}| Name|-| QB Class| {{Arrow|Right}}| Class|-| Date and Time| {{Arrow|Right}}| Date and Time|-| FB Debit Amount| {{Arrow|Right}}| Inventory Asset Account|-| FB Credit Amount| {{Arrow|Right}Mapping}| Inventory Adjustment Account|}

Navigation menu