Copy and paste unmatched bank items and paste in to excel

Question asked by Elaine Roscoe 10 years ago

Hi, I am new to clearbooks and fairly IT competent but not enough to know how to copy unmatched bank items and paste in to an excel sheet to let client know which items I have invoices missing for.

There are already items in there from previous months and now I have to add in the months I am working on. When I look at the excel sheet and click on existing items it maps me back to the bank statement so I think it is something to do with the import tool but not 100%. Hope that makes sense and that someone can guide me to move other transactions across.

Elaine

6 Replies

Hi Elaine - see my comment on Kevin's linked post.

This is one of a very few areas in accountancy that has not changed since the days of paper books, ie I would send the client the bank statement and ask them to scribble next to each item what they were for, before, entering up the books. So, today, if I have bank entries I know are a mystery I just send the statement csv to the client and get them to write notes against highlighted or all items.

For me the object always is to get the clients to do as much as they are willing and able to do and this is a good precursor to getting them involved in keeping their own books with us checking/supporting.

I have just managed to copy and paste 12 ish transactions from the import explain screen to a new excel spreadsheet. Although it would appear that I have to start with an explained item so that the cells are "dead" when clicked on. You could then delete the explained lines leaving the queries and forward the sheet.

You need to filter it first so you've only got the unexplained items.

Then copy and paste everything into Notepad to remove the formatting.

Then copy and paste into Excel.

Not ideal but do'able.

Hi, Currently all unexplained items and transactions are listed by statement, so you have to go into a listed statement to see the individual transactions. We don't currently offer the option to view just the individual items, but if you support Kevin's post, this will help as it is better to have a single, highly supported post than many individual idea.

In the meantime, Kevin's method is your best bet.

Thanks

Chris

Hi Elaine - see my comment on Kevin's linked post.

This is one of a very few areas in accountancy that has not changed since the days of paper books, ie I would send the client the bank statement and ask them to scribble next to each item what they were for, before, entering up the books. So, today, if I have bank entries I know are a mystery I just send the statement csv to the client and get them to write notes against highlighted or all items.

For me the object always is to get the clients to do as much as they are willing and able to do and this is a good precursor to getting them involved in keeping their own books with us checking/supporting.

^^^ Whilst I agree with the majority of your post Paul I do think CB's should work towards a system whereby the exchange of emails, csv's and screenshots is a thing of the past.

Reply to this question

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are