Importing bank transactions

Importing transactions from your bank account*

After you have connected your financial institution account to your WorkingPoint bank account, you can import transactions from your bank directly into WorkingPoint to save time and cut down on common data entry errors.

To import transactions from your bank:

Go to the Accounts List, click the name of your bank account and then from the right hand sidebar, under Financial Institution Connection, click Import Transactions.

All of the financial institution transactions that are available for import or matching to your bank account activity in WorkingPoint will be displayed. If this is your first import, we'll bring over transactions from as far back as we can (typically 90 days or so). Going forward, each time you import we'll show you all of the new transactions dating back to your last import, along with previous transactions you either chose to "import later" or just didn't get to.

Review the bank transaction details.
For each transaction your bank reports, you'll see the following details:

Date - This is the date the transaction was reported to the bank and the date the transaction will be recorded in your account when imported. If matched, the transaction date remains the date you entered the transaction into your account.
Amount - This is the amount of the transaction. WorkingPoint uses the amount to locate other transactions to match to. If importing, you can record a new transaction in WorkingPoint for this amount.
Description - This is the details the bank has on your transaction, including, the type of transaction (Deposits, Payments, etc.), the name of the vendor, financial institution transaction numbers or other codes.
In and Out Icons - These icons help you spot whether money is going into the account(Deposits, Transfers, etc.) or going out of the account(Payments, Transfers, etc.).

Indicate how you'd like to handle it: Import it, Match it or Don't Import.

Importing transactions
WorkingPoint will display one or more forms for recording the transaction, based on its characteristics. The one that we think is the best fit will be displayed first with the others accessible via tabs on the left side of the form. If none of the options that we present are appropriate, click more options to select from all the possible transaction types. By importing a transaction, you are creating a new transaction in WorkingPoint.

To import a transaction:

Choose the tab to display the form you would like to use to record the transaction.
Transaction Type Options

Money going out - These forms appear for all transactions that decrease your bank account balance.

Transaction Type	When to Use	Notes
Cash Withdrawal	Use this form to record a withdrawal of cash, like from the ATM.	Choose the bookkeeping account that best describes what you spent your money on. If it was for personal use, you might want to choose Owner's Equity:Draw.
Credit Card Payment	Use this form when importing a payment you made on a credit card account.	In the Payment on Credit Card field, select the credit card you made a payment on. If you don't manage the credit card in WorkingPoint, choose more options to select another transaction type.
Expense	Use this form when importing a payment or purchase you made.	Choose the bookkeeping account that best describes your purchase. If you bought inventory, choose the items you purchased, quantity and cost to ensure accurate inventory counts.
Funds Transfer	Use this when you are importing a transfer of money from one bank account to another.	Select the account that you transferred the money to. If the "to" account is not managed in WorkingPoint, choose more options to select another transaction type.
Bill Payment	Use this form to record a payment you made on a bill that is already recorded in WorkingPoint. We'll show you all the bills that match amount of the transaction but you can also search all bills.	WorkingPoint will try to match your payment amount to any open bills with the same balance. Select the one that matches or search for open bills by vendor and select from the list provided.

Money coming in - These forms appear for all transactions that increase your bank account balance.

Transaction Type	When to Use	Notes
Deposit	Use this when you are importing a deposit you made that was not related to an invoice, like for a rebate.	Choose the bookkeeping account that best describes what you got the money for, rebate on office supplies: choose office supplies.
Funds Transfer	Use this when you are importing a transfer of money from one bank account to another.	Select the account that you transferred the money from. If the from account is not managed in WorkingPoint, choose more options to enter the transaction as a deposit.
Invoice Payment	Use this when you are importing a deposit that was from a payment made on an invoice you created in WorkingPoint.	WorkingPoint will look for all open invoices with a matching balance. Select the invoice that matches the payment or search for open invoices by customer and select from the list provided.

WorkingPoint will auto-fill as much of the form as we can based on the transaction details provided by the bank.

Enter any additional information you would like to add to the transaction.

If the transaction total is for more than one bookkeeping account, click Add Line to unlock the transaction amount, choose more bookkeeping accounts and distribute the amounts to all accounts.
If the transaction involves an inventory purchase, check the "This purchase contains items to add to inventory" checkbox and select the inventory item, the quantity purchases, cost per unit and verify the amount. You may need to clear the bookkeeping account total above to complete the import.
If the payee or payor is saved in your Contacts List, WorkingPoint will auto-suggest a match for you. If the contact is not in your list, we'll save the information as part of the transaction.
Add a Memo or Note.

Click Import.

Matching transactions
If a the amount of a transaction matches the amount of one you already have in WorkingPoint, we'll give you the option to “match” the financial institution transaction with the one you have in WorkingPoint instead of import it, so you don't end up with duplicates.

To match a transaction:

From the Match Transaction tab, locate the transaction recorded in WorkingPoint you want to match the bank transaction to. If you need more information about a transaction to confirm it's the one to match, click the Transaction link to view more details.
Click Match.

Don't Import
Not sure if you want to import a transaction or sure you don't want to? Click the Don't Import tab and you'll be given options to:

Import Later - Click this link and WorkingPoint will save the transaction until the next time you want to import.
Never Import - Click this link if you don't ever want to import it into WorkingPoint and we'll remove it from the Import Transactions List permanently.

Once a transaction has been imported, matched, deferred or removed, the transaction will disappear from the Import Transactions page, so you can move on to the next transaction. When the list is clear, you have completed importing all current transactions.

Tip: When a transaction has been imported or matched, WorkingPoint flags the transaction as imported/matched by adding a imported icon to the entry in the bank account. Hover over the icon to view import/match details about the transaction.

*Access to this feature may depend on your account plan. Log into your WorkingPoint account and click "Account" (in the upper right hand corner), then "Change account plan" to view your plan details.

Importing transactions from your bank account*

Related Topics