Pinterest

Financial Exchange: Setup QuickBooks Desktop Connection Now in Point of Sale

Your daily point-of-sale business transactions, such as buying, receiving, and selling goods, as well as keeping track of inventory and […]

Voiced by Amazon Polly

Your daily point-of-sale business transactions, such as buying, receiving, and selling goods, as well as keeping track of inventory and customers, are tracked by QuickBooks Desktop Point of Sale. In contrast, QuickBooks Desktop assists you with bill payment, cash flow management, customer invoicing, and financial report generation. Information sharing between these two systems is called a financial exchange, and it often takes place at any time or as part of your end-of-day procedure. Financial Exchange prevents you from entering the information twice, thus reducing your effort. The aspects of both programs that are permitted during Financial Exchange are described in this article.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

Financial Exchange Setup

The following prerequisites must be fulfilled before you may connect QuickBooks Desktop Point of Sale to your QuickBooks Desktop program and share data:

  • Install QuickBooks Desktop Pro, Premier, or Enterprise in supported versions on the same machine as POS. Be aware that POS version 18 will function correctly with any supported QuickBooks Desktop version.
  • Both your QuickBooks Desktop Point of Sale and QuickBooks Desktop files should be backed up. Give the backup a name that will help you distinguish it, like QBPOS backup before QB.
  • Follow these steps in QuickBooks Desktop:
    • Activate sales tax
    • Turn on the stock
    • Set your options so that Financial Exchange can be used without QuickBooks Desktop being open. Although Finance Exchange is best used with QuickBooks Desktop open, it can also be used when the application is closed. To accomplish this, set the following QuickBooks parameters:
  • Choose Preferences under Edit from the menu.
  • Select Integrated Applications from the left window, and then select the Company Preferences option.
  • Select QuickBooks Point of Sale, then Properties, from the Applications list.
  • Choose the option to let this program read and modify this company file under the Access Rights tab.
  • In both the Properties and Preferences windows, click OK.

How to Initiate a Financial Exchange

Before beginning a financial transaction, remember the following:

  • Only the Server Workstation can be used for financial transactions.
  • You must have your financial software preferences configured to allow automatic access during exchanges or have your QuickBooks Desktop Company file open.
  • A summary window that appears when the exchange is finished shows how many records were exchanged and whether any mistakes took place. To learn more about any errors those is shown and for assistance, select View Activity Log from this box.

There are two methods for carrying out a financial transaction:

As Part of the Day’s End Process

  • Select Point of Sale > End of Day Procedure on the QuickBooks Desktop Point of Sale Server Workstation.
  • Make sure the Exchange Data with QuickBooks check-box is selected on the End of Day window.
  • Select additional End of Day choices as desired.
  • Choose OK.

Manual Switch

  • Choose Financial Center, and then choose QuickBooks Now, from the financial menu.
  • If you want to ensure that you have the most recent QuickBooks Desktop Point of Sale data or if you want to perform mid-day billings from QuickBooks Desktop, you can use manual exchange.

Affected Accounts, Activities, and Data during the Exchange

Data Exchanged During the Transaction

Data is sent from Point of Sale to QuickBooks Desktop and vice versa when completing financial exchange.

Note that we strongly advise you to add or change items, customers, and vendors in POS until after you have started sharing data with QuickBooks Desktop in order to minimize discrepancies and save time during data review.

From Point of Sale to QuickBooks Desktop

  • Updated Customer Data and new Customers, Except Account Balances and limits
  • Updated Vendor information and New Vendors
  • Data Regarding Sales (Receipts)
  • Obtaining Knowledge (Vouchers)
  • Adjustments to Inventory Quantity or Cost (as a summary adjustment Journal Entry)
  • New terms for Vendor Payments

From QuickBooks Desktop to Point of Sale

  • New Clients
  • Updated Customer Account Balances and Limitations
  • New Suppliers
  • New Terms for Vendor Payments

Activities done between QuickBooks Desktop and QuickBooks Desktop Point of Sale

Note: This is not an all-inclusive list of the features in either program

ActivityPOSQBDT
Add/track inventoryX
Order and receive merchandiseX
Make sales and collect sales taxX
Run sales and merchandise reportsX
Add customers or vendorsXX
Enter vendor billing info (invoices)XX
Track cost of goods and expensesX
Pay bills and sales taxesX
Invoice customersX
Process payrollX
Run financial reportsX
Banking activitiesX

Accounts Affected by Financial Exchange

Accounts affected in QuickBooks DesktopQuickBooks Desktop Point of Sale data affecting the Accounts
Inventory Asset AccountVouchers, Return vouchers, Sales receipt, Returns, Adjustments, and other transactions
Cost of Goods SoldSales and Returns
Bank accounts, undeposited funds and cash in drawer AccountsSales, Returns, and Pay outs
Accounts PayableVouchers and Return vouchers
Accounts ReceivableSales and Returns
Unbilled Purchases AccountVouchers
Document Offset accountAdjustments
Sales Tax Payable accountSales and Returns
Gift certificate accountsSale and Redemption of Gift Certificate
Vendor discounts accountVouchers
Sales related income accountsSales and Returns
Purchasing expense accountVouchers
Shipping and handling accountSales
Paid out expense accountPay outs

Default Accounts Mappings

QuickBooks Point of SaleQuickBooks AccountAccount Type
Cash in DrawerCash in DrawerBank
CheckUndeposited FundsOther Current Asset
Credit CardUndeposited FundsOther Current Asset
Debit CardUndeposited FundsOther Current Asset
Gift CertificatesGift Certificates OutstandingOther Current Liability
Gift CardGift Cards OutstandingOther Current Liability
Accounts ReceivableAccount ReceivableAccounts Receivable
Sales TaxSales Tax PayableOther Current Liability
Customer Order Deposit TakenCustomer DepositsOther Current Liability
Purchase ClearingUnbilled PurchasesOther Current Liability
Voucher AdjustmentPurchase DiscountsCost of Goods Sold
Freight InFreight & Shipping CostsExpense
Voucher FeeFreight & Shipping CostsExpense
Accounts PayableAccounts PayableAccounts Payable
Document OffsetPOS Inventory AdjustmentsCost of Goods Sold
ShippingShipping and Delivery IncomeIncome
Pay out ExpenseCash Drawer PayoutsExpense
TipsEmployee Tips PayableOther Current Liability
POS Balancing AdjustmentsBalancing AdjustmentsOther Expense

Default Item Account Mappings

Whenever various item categories are purchased, item sales (Income), Cost of Goods Sold (COGS), and inventory value (Asset) quantities are sent to the designated item accounts. As new things are added to storage, default profiles are given to them. You can choose to assign accounts to individual things on the item record in Point of Sale stock, make changes to all current goods, or create sub-accounts by department.

POS Item TypeIncome AccountCOGS AccountAsset Account
InventoryMerchandise SalesCost of Goods SoldInventory Asset
Non-inventoryMerchandise SalesPurchases- Resale ItemsPurchases- Resale Items
ServiceService SalesSubcontracted servicesSubcontracted services
AssemblyMerchandise SalesCost of Goods SoldInventory Asset
Special OrderMerchandise SalesCost of Goods SoldInventory Asset
GroupNot applicable. Group items will map to their component items.

Set up QuickBooks Desktop Connection Now in Point of Sale

  • Go to Preferences > Company > Financial > Set up QuickBooks Desktop Connection Now in Point of Sale from the File menu.
  • If you’ve already logged in to QuickBooks, you might receive the following message:
  • Use this company file as before or I’d like to select a new company file.
  • Select let me select a new company file option every time.
  • Making a new selection has no impact whatsoever on your data.
  • You’ll be asked to launch QuickBooks and log in as the administrator. Choose Next.
  • Data sharing between QuickBooks Desktop Point of Sale and your accounting software is now possible. Press Finish button.

How to overcome the Problem with Financial Exchange

Due to two QuickBooks windows being open on the server, there is no financial exchange at day’s end. QuickBooks Financial won’t open on the server. Nothing is open in Task Manager, and all PCs running QuickBooks Financial are shut down. Any of the following could be a reason for the error you’re receiving:

  • QuickBooks Desktop is currently logged in by a non-admin user.
  • The most recent release of either QuickBooks Desktop Point of Sale or QuickBooks Desktop is not installed.
  • In QuickBooks Desktop, the Integrated Applications preference is broken.

We will outline several steps you can take to fix the problem

Integrated Applications should be Updated

  • In QuickBooks, you will have to select Preferences from the Edit menu option.
  • Then select the Company Preferences tab after moving to the Integrated Applications tab.
  • Choose QuickBooks Desktop Point of Sale from the list of applications, then click Properties.
  • Note the name in the Login as field on the Access Rights button and uncheck the box next to Allow this program to access and edit this company file.
  • To save the changes, click OK.
  • Now, click the box that says Allow this application to read and edit this company file.
  • Choose the name that was previously used in the Login as field. Choose OK twice.
  • Launch QuickBooks Desktop Point of Sale’s money exchange.

Refresh the Channel of Communication between Point of Sale and QuickBooks Desktop

  • Open both programs at once.
  • Go to File in POS, select Preferences, and then select Company.
  • Choose Financial, uncheck the box that says Use with QuickBooks Financial Software and then save your changes.
  • Select Preferences from the Edit menu on QuickBooks Desktop.
  • Click the Integrated Applications tab to continue.
  • Search for QuickBooks Point of Sale under the Company Preferences tab, and then click Remove.
  • Remove this program warning box: click YES, and then click OK.
  • Go to Financial > Financial Center > Set up QuickBooks Connection Now in POS to complete the setup by following the Connection Wizard’s instructions.
  • Run a financial exchange once more when you’re finished to make sure you can still handle it.

We believe the aforementioned guide can assist you regarding Financial Exchange. Hopefully, this article provides you detailed overview on Financial Exchange including its setup and process. But if you are unable to comprehend it or become stuck at any point, our Dancing Numbers experts will help you do your task quickly and effectively.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-347-428-6831 or chat with experts.


Frequently Asked Questions (Faqs)

How can I Change User Access as an Admin?

You can alter user access as an admin as a workaround. This is how:

• Open the Windows Start menu after closing QuickBooks Desktop.
• Select User Accounts after opening the Control Panel.
• Locate the QBDataServiceUserXX for QuickBooks Desktop in your version. Search for QBDataServiceUser30 in QuickBooks Desktop 2020. Look for QBDataServiceUser29 for the 2019 version.
• Choose change the account type option and then select Administrator. Select Change Account Type after that.
• To save your changes, click Apply.

How can I Resolve the Errors While Doing the File Exchange?

Please make sure QuickBooks Desktop has the Server Host Service turned on. We may be encountering issues with the file exchange because of this. After that, take the next few steps:

• Go to the File menu in QuickBooks Desktop and select Switch to Single-User Mode.
• Select Preferences and then Integrated Applications from the Edit menu.
• Select the tab for Company Preferences. Click Remove after selecting QuickBooks Desktop Point of Sale.
• To save adjustments and launch a new Financial Exchange, press OK.

It is preferable to contact our Support Team so they can look into this if the problem is still not resolved.

Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Book your consultation Book Free Consultation
Close X
Call Now+1-800-596-0806
Dancing Number

We value your privacy and are strongly against any kind of phishing, spam, and malware. We collect your information for our legitimate business purpose only. This information is safe with our in-built security.

X



    Top