Skip to main content

Bank Data Import

Learn how to add the transactions downloaded from a bank or credit card account.

Bobbie Combs avatar
Written by Bobbie Combs
Updated over 2 months ago

The Bank Data Import shows transactions automatically downloaded from your bank or credit card account allowing you to easily add those transactions. These transactions could already be in your Design Manager as a Vendor Invoice, Company Wide Expense (Expense/Bill/Miscellaneous), or a Deposit on a Purchase Order. When reviewing and assigning the transactions in Bank Data Import, you have these options: transaction suggestions, add the transaction or override the transaction.

If you have not already connected a bank or credit card account, click here to learn how to connect your accounts to see the transactions in Bank Data Import.

You can view your Bank Data Import by going to Accounts Payable in the black navigation bar to the left and clicking on Bank Data Import.

Select the connected account you would like to see in Account.

Review each transaction and when you are ready to assign the transaction into Design Manager click on Assign. You will have three assign options to choose from:

Suggested: Will show any transactions already in Design Manager that matches the Amount only. If the suggestion matches exactly (Vendor, Date, Amount, and PO if applicable), select the Suggestion by clicking to the left of the suggestion and then click on Confirm.

When the suggestion is matched to a PO, you'll be prompted to enter a Vendor Invoice. Check over the information, enter a Vendor Invoice and No., make changes if necessary and click on Save. When saved the Vendor Invoice will be created and posted. In Bank Data Import, transaction will be removed from the New tab and can be found in the Assigned tab

When the suggestion is matched to a Vendor or General Invoice, the transaction in Bank Data Import will be removed from the New tab and can be found in the Assigned tab.

If you are unsure about the suggestion, find the suggested transaction in Design Manager and review further before confirming. If there are no suggestions shown or the suggestion shown is not a match then select the Add option.
​


​

Add: Will show types of transactions to add.

  1. Company Wide Expense: This would be an expense such as advertising or an internet bill for which no Purchase Order is needed. When selecting this transaction, Design Manager will open the Expense/Bill/Miscellaneous window for you to enter the company wide expense. Note: some of the information downloaded from your account will show in this window. To learn more on how to enter this Expense/Bill/Miscellaneous, click here.

  2. Project Expense without a Purchase Order: This would be an expense or purchase on a project for which no Purchase Order is needed. When selecting this transaction, Design Manager will open the Expense/Bill/Miscellaneous window for you to enter the project expense. Note: some of the information downloaded from your account will show in this window. To learn more on how to enter this Project Expense/Bill/Miscellaneous, click here.

  3. Full Payment of a Vendor Invoice: This would be full payment to a vendor for a Purchase Order already created. When selecting this transaction, Design Manager will open the Add Invoice window for you to enter the vendor invoice. Note: some of the information downloaded from your account will show in this window. You will need to select the Purchase Order this Vendor Invoice is for. To learn more on how to enter this Vendor Invoice, click here.

  4. Deposit towards a Purchase Order: This would be a deposit to a vendor for a Purchase Order already created. When selecting this transaction, Design Manager will open the Add Deposit window for you to enter the vendor deposit. Note: some of the information downloaded from your account will show in this window. You will need to select the Purchase Order this Vendor deposit is for. If this deposit is final payment on a Purchase Order, do not use this transaction type to assign. Use the Full Payment of a Vendor Invoice transaction type. To learn more on how to enter this Vendor Deposit, click here.

Select the type of transaction by clicking to the left of the transaction and then click on Create.

Depending on which transaction you select, Design Manager will open a transaction window for you to add or create the transaction in Design Manager. Once the transaction has been saved, it will automatically be posted and the transaction in Bank Data Import will be removed from the New tab and can be found in the Assigned tab.

Override: Will mark this transaction in Bank Data Import as cleared and will not be added to your Design Manager as a transaction. An example of using this option would be if you know the transaction is already in your Design Manager but no suggestions were shown. When the Override is confirmed, the transaction will be removed from the New tab and can be found in the Assigned tab even though no assignment was made. The transaction already in your Design Manager would need to be cleared manually during Reconciliation.

When transactions are assigned by selecting the suggestion or adding the transaction, they will be automatically cleared when you go to Reconcile that account they were paid with.

Transactions can not be undone once assigned by selecting the suggestion, adding or overriding. If you assigned a transaction in error through the Bank Data Import, contact support@designmanager.com to help with reversing the transaction and if needed entering the transaction correctly.

Did this answer your question?