You'll need to connect your bank account to Pandle in order to enter new transactions using a bank feed. Read our guide to Setting Up Bank Feeds to get started.
Using a bank feed to automatically enter transactions from your bank means you won't need to enter or import information manually.
The data comes directly from your bank, so you won't need to reconcile bank feed transactions in Pandle. Instead, you can set up Bank Rules for Pandle to categorise your transactions automatically, or you can check and confirm them.
Click 'Banking' in Pandle's navigation menu, and select 'Bank Accounts'.
On the Banking screen, click the tick icon in the same line as the bank account name.
You'll find it here:
This will take you to the Bank Entries screen, which shows your feeds and imports in Pandle. Click the tick icon next to the bank feed you wish to check.
Now you will see a list of transactions entered into Pandle from your bank feed. Your transactions will appear in date order.
How will I know if I have transactions to confirm?
The 'Check' tab header will show the number of transactions waiting to be checked, and the tab itself will show the list of transactions that need attention. In our example below, there are 6 transactions waiting to be checked.
Check each transaction listed in the 'Check' tab. Some information will be filled in automatically using the data from your bank feed, but you will need to provide other information in order to confirm your transactions and save them in Pandle. For instance, by selecting what type of transaction it is.
You may notice that some recent transactions are not included in the 'Check' tab. This can happen when they still show as pending with your bank.
Pending transactions can be viewed in the 'Pending' tab, but to help reduce the risk of errors, you won't be able to check and confirm them in Pandle until the bank finishes processing them.
The date of the transaction will populate automatically from your bank feed. You won't be able to edit this in the 'Check' tab.
There are four types of transactions to choose from.
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!).
Entering a description helps you understand what the transaction relates to if you refer back to it later. This can be copied from the bank, or you can make up your own.
This will show the base currency of the transaction as it appears in the bank.
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!
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.
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.
Sometimes transactions show on your bank statement as 'pending'. The transaction has occurred, but is still being processed by your bank.
Every bank is different, and some transactions can have a pending status for up to 10 days.
Transactions which appear in the 'Pending' tab in Pandle will move into the 'Check' tab once they have fully cleared, allowing you to check and confirm them.
Transactions which you delete or 'Ignore' whilst checking your bank feed will be moved to the 'Ignored' tab. You can restore them to the 'Check' tab at any time.