Putting Transactions into QuickBooks
Home
Developer's Notes

Product Information
Remote Register
  Main Screen
  Account Mgmt
  Data Transfer
  User's Manual

Remote Register for QuickBooks
  Introduction
  Main Screen
  Export List Data
  Import Transactions
  User's Manual


Feedback
Testimonials

Purchasing
Order Form
Downloads/Upgrades
Free 60 Day Trial

Support
Forum
Contact Us
Importing Transaction Information

Click to see a larger view

Once the transactions are exported from the Pocket PC Remote Register software, you then load the display grid. The transactions that were exported are then displayed on the grid. At that point you can validate the information and prepare it to be put into the QuickBooks® company file.

For example: in the Remote Registry software on the Pocket PC you may have added Accounts and Payees in addition to the Accounts and Payees/Contacts that were transferred to the Pocket PC from this software. The Accounts and Payees that were added and are not recognized as being transferred from the QuickBooks® company file appear with a Yellow background.  Notice the “New Account” debit account, the “New Payee”, or the “Football Pool” credit account in the grid. These were added in the Remote Register Pocket PC software and did not come from the QuickBooks® Company file. Before moving the transactions into the company file, you have the opportunity to replace the entry with an Account or Payee from the QuickBooks® Company file clicking the drop down button in the cells that have them. An appropriate window will appear where you can select an Account or Contact to use. (You can also change the Date, Transaction Type, Ref #, and Amount if you find it necessary.)

Any accounts/payees that have a yellow background when they are transferred to the QuickBooks® company file will be Added to the company file.

The following logic is used to add Accounts/Entities.

For New Debit Accounts: These are always added as a QuickBooks® “Bank” account type.

For New Payees: If the Transaction Type is a withdrawal from an account, the Payee is added as a new QuickBooks “Vendor”, otherwise for “Deposit” transactions, the Payee is added as a QuickBooks “Customer”.

For New Credit Accounts: If the Transaction Type is a withdrawal, the new account is added as a QuickBooks® “Expense” account. Otherwise, for Deposit transactions the account is added as a QuickBooks® “Income” account.

When the “Transfer” button is clicked, the transactions that have a check mark in the “Transfer” column are added to the QuickBooks® company file. Each transaction is added to its appropriate account register. After the transfer process is complete, all transactions that were successfully transferred are removed from the grid.

If there was a problem adding a transaction, the transaction will NOT be added to the QuickBooks® company file and will remain on the grid after an explanation of what is wrong is displayed. Then the problem areas are marked in “red” (see the screen shot above) so you can make corrections and then transfer those transactions again.

Toolbar Functions
Clear Grid: Removes all transactions from the Grid

Load Grid: This is a drop down menu providing you to the option to get the import file directly from your Pocket PC. (Providing it is in its cradle, powered on and synchronized with your PC) . Or, from a file that you manually placed on your PC (perhaps using the ActiveSync “Explore” option).

Transfer: Moves the selected (or checked) transactions to the QuickBooks® company file.

Tools: No Sorts are provided as transactions need to be sorted in Debit Account and Date order. However, Check All, Un-Check All functions are provided.
Created by Genesis Software Corp. Copyright © 2005 Genesis Software Corp.