HOME / COMMUNITY Switch to knowledge base

Export Bank Account Transaction


#1

I would like to export all of my account transactions so I can manipulate the spreadsheet and reimport them purchase invoices and client invoices.

I notice I can only do one page at a time, is there a way to export all transactions.

Also I have checked the bank account balance matches with my bank. What happens when you use the reconcile option?


#2

Hi @gbhec

The reconcile option is a tool that just helps ensure your QuickFile bank account matches your actual bank account. It doesn’t add or remove any entries, it’s mainly just a matching exercise. There’s a few more details on this here:

You’re correct in regards to be export option - it is limited to just what you see (at most, 50 transactions). But you can get a full export of the bank, amongst other data, by running an account back up. Please see the below for instructions:

I hope that helps! :slight_smile:


#3

Thanks it did. I have managed to separate the sales and purchase and I’m going to re-import the data.

I have however noticed all transactions from my EURO account show (I assume) in GBP as the amount is different to the actual. So if i now try and import these transaction back are all the amounts not going to wrong?

As part of importing Purchase Invoice Data I would like to enter the Nominal Code, however I cannot seem to find a list of numbers match the system codes. Can you direct me please to where I can find the list?

Thanks


#4

Not to worry about the Nominal Codes as I have just come across them under the Chart of Accounts in the Report section.


#5

Have you been able to find out anything on this issue?


#6

If the account is in a different currency them GBP, I believe it should show both the GBP and foreign currency alternative. Is this not the case with your backup?


#7

Hi, no the backup just had the amount column and it looks as though it’s converted all the amounts into GBP. There was no additional column showing currency or exchange rate.


#8

I also notice this topic will close automatically in 1 day. Can this be extended?


#9

I believe there should be a matching amount here. I’ll refer this to our development team and see what they say - they would know better than what I do.

Of course. If it did close, we would reopen it until the issue has been resolved.


#10

Hi,

Has there been any update on this?


#11

@gbhec - I’m just waiting on a response from my colleague regarding this and one of us will come back to you.


#12

Hi,

Has there been any update on this?


#13

Hi @gbhec

It’s showing as resolved on 18th and deployed on the 21st. Sorry for not updating you sooner.

Please let me know if you encounter any further problems.


#14

This topic was automatically closed after 21 days. New replies are no longer allowed.