If you don't use automatic bank feeds to enter new bank transactions into Pandle, then using File Imports is another way to enter transactions without lots of manual data entry.

Important: You will need to set up your bank account in Pandle before you enter transactions for it.

What banks and institutions are supported by Pandle File Imports?

Using File Imports to enter bank transactions

Confirming your transactions

Ignore a transaction

Split transactions between multiple categories

Add attachments to transactions

Dealing with overpayments

Confirmed transactions

Related articles

What banks and institutions are supported by Pandle File Imports?

Pandle already has built-in default formats for most main banks, or you can create your own custom file import format in order to upload bank statements into Pandle from any bank.

These file import formats tell Pandle what each column of information means in the file that you upload, so that the software can create transaction records for you.

Using File Imports to enter bank transactions

You can start a new File Import either through the Quick Links menu, or through your Banking screen.

To use the Quick Links menu, click the 'Quick Links' icon in your Pandle navigation, and select 'New Bank Transaction'.

To access it through the Banking menu, click 'Banking' in your Pandle navigation, and select 'Bank Accounts'.

Then click the 'Enter Transactions' button.

Use the dropdown menu in the pop-up box to select the bank account you are entering transactions for, and click 'Enter Transactions'.

This will take you to the 'Bank Entries' screen for File Imports. It will show a list of any previous imports uploaded into Pandle.

Click 'File Import'.

On the upload screen:

  • Enter a description (it's useful to use the time period which the upload covers)

  • Use the dropdown menu to select the upload type (so that Pandle knows which format template to use, so that your banking information is imported in the correct order)

  • Download the file from your bank account, and drag and drop it on screen, or use the 'Browse Files' button to select it from your device.

Click 'Save And Upload' to import your file, or 'Cancel' to return to the Bank Entries screen.

Confirming your transactions

The upload may take a few moments depending on the size of the file. Once complete, you'll be able to check and confirm your transactions into Pandle from the Bank Entries screen (or learn more about setting up Bank Rules to automate this process).

Check and confirm

Click the 'Check & Confirm Transactions' button next to your file import.

Select the 'Check' tab. A counter icon will show how many transactions are waiting to be checked.

Some information will be filled in automatically using the data from your file import, but you will need to provide other details to confirm your transactions and save them in Pandle. For instance, by selecting what type of transaction it is.

Date

The date of the transaction will populate automatically from your import. You won't be able to edit this in the 'Check' tab.

Type

There are four types of transactions to choose from.

  • Money In

    Money that you receive into your bank account that is not from a customer paying an invoice. For instance, loans received, refunds, grants.

  • Money Out

    Money going out of your bank account that is not to pay a supplier's invoice. For instance, if you buy something for the business and pay for it at the time of purchase.

  • Customer Receipt

    Money that you receive from a customer paying an invoice. Read the section below about dealing with customer overpayments if this applies to you.

  • Supplier Payment

    Money that you send to suppliers to pay an invoice they issued to you.

Category

  • If the transaction is a Customer Receipt (CR) or a Supplier Payment (SP)

The category column will allow you to select which customer or supplier it relates to.

Once you select the customer or supplier, the 'Invoices' button will illuminate.

Click the 'Invoices' button, and select the invoice(s) which the payment relates to, and click 'Done' when you're finished.

  • If the transaction is Money In (MI) or Money Out (MO)

Assign a category to the transaction by clicking 'Select An Option'. You'll be able to choose existing categories from the dropdown menu, or click 'Add New' to create a new one. You can also split transactions between different categories.

In some cases assigning a category will automatically populate the tax columns (which we explain further down!).

Description

Use the description copied from the file import, or overwrite it with something else.

Currency

This will show the base currency of the transaction as it appears in the bank.

Tax code

If your business is VAT registered you'll need to enter a tax code for 'Money In (MI)' and 'Money Out (MO)' transactions. This field will populate automatically when you select certain categories.

For instance, if you're VAT registered and you assign the category 'Sales', then the tax code field will automatically show 'ST - Standard VAT'.

You won't need to select a tax code for transactions which are a Customer Receipt (CR) or Supplier Payment (SP). This is because you already provided the tax code when you created or entered the invoice. Once you select the invoice which relates to the transaction, the tax field will populate automatically.

Complete each column, and click the 'Confirm' check box. You won't be able to tick transactions with incomplete data, and you will see a warning icon if you hover over the box.

Then click 'Confirm Checked' to confirm your transactions.

Ignore a transaction

Click the 'Ignore' icon next to a transaction to ignore it.

Click 'OK' in the popup confirmation box to continue, or cancel to close the confirmation box without ignoring the transaction.

The transaction will be moved to the 'Ignored' tab.

You can send it back to the Check tab by clicking the 'Restore' icon in the 'Actions' column.

Split a transaction between different categories

Click the 'Split' icon in the Actions column for the relevant transaction.

Confirm the categories to split the transaction between. You can add more categories by clicking the 'Plus' icon. Click 'Save' to split the transaction, or 'Unsplit' to return to the checking screen. Read our guide to Split Transactions.

Add an attachment to a bank transaction

You can attach documents to specific transactions in Pandle to help you manage your records more easily. Read our guide to uploading and storing receipts and documents in Pandle.

To attach a document to a bank feed transaction, click the 'More Actions' icon in the Actions column.

Then select 'Attachments' from the menu.

You can either select documents already uploaded into Pandle from the 'Link To An Existing File' tab, and click 'Done' to confirm.

Or upload or capture new documents by clicking the 'Upload A New File' tab.

Set up a new Bank Rule

Bank Rules help to automate more of your bookkeeping by telling Pandle how to categorise transactions.

For instance, if you regularly have a high volume of transactions relating to a particular supplier, and they are always for the same category and tax code, you can set up a bank rule to process them for you.

Our guide to setting up Bank Rules explains the process in more detail, but you can use specific transactions to help you set up Bank Rules in order to treat future transactions the same way.

Click the 'More Actions' icon in the Actions column.

Select 'Create Bank Rule' from the menu.

How do I deal with customer overpayments?

There may be times you enter a Customer Receipt transaction into Pandle and the customer has overpaid you (i.e. the amount you receive is more than the amount have invoiced the customer).

For example, if the outstanding amount on a client's account is £50, but they pay you £60, Pandle will automatically populate the overpayment field to show the £10 difference.

The overpayment will be saved on their account. The next time you invoice the customer, the overpayment will be deducted from their balance in Pandle automatically.

What if I overpay a supplier?

If you overpay one of your suppliers, Pandle will automatically calculate the difference between your supplier invoices and supplier payments (similar to how customer overpayments work in the previous section).

The difference will then show on the supplier's account in Pandle, and will be automatically offset against the next invoice from them that you enter. That way you won't over pay them!

Confirmed transactions

The 'Confirmed' tab will show a list of transactions you have checked and confirmed in Pandle for this account.

You can attach documents, make any changes (for example, if you enter the wrong category), delete transactions, and create Bank Rules using the icons in the 'Actions' column.

Search for confirmed transactions

You can search for specific transactions quickly by entering information into the search bar. Pandle will display any results which include the search term you enter. Delete your search term from the entry box to return to a full list of results.

Sort transactions

Click a column header to sort your confirmed transactions, or click the header again the reverse the order.

Choose how many rows per screen

In Pandle you can choose how many rows of information you see on a screen. Just click the 'Row Count' button, and select the amount from the menu.

Related articles

Banking

Add a bank account

Creating custom bank imports

Split transactions

Creating a bank rule

Did this answer your question?