Clean It Up
UK Window Cleaning Forum => Window Cleaning Forum => Topic started by: Clive McDonald on January 23, 2011, 01:48:55 pm
-
I'm trying to get better and more organised at reconsilliation.Here's what i've come up with.Anyone got any better ideas?
1.Down load months accounts from bank into excel.Rename and save as month and year (december10) for example.
2. Drag wcp down to lower half of screen in search.Put excel at top.Search each name.
Question, how best to show on the spreadsheet that i've reconciled it?
Question, the names i can't find, how best to highligh them so i can find them at another time (customer says oh i did pay you but my girlfriend surname is different etc)
Any help, tot tips gratefully recieved
-
If you highlight the information downloaded from the bank and hit insert table, this will turn all the information into table format, you can then insert an extra column which you can check off as you enter it into your database. If you then click the top of the table you can filter out checked transactions, leaving only unassigned payments.
-
I've got it highlighted- but i'm stuck on the insert table bit.
I think what you've suggested is a very neat way of doing it.Please advise.
-
Which version of excel do you have?
-
The latest. I think it's 2007
-
OK good, same as me.
Highlight all the information then look across the top menu you will see 'insert' click it and you will see on the lefthand side 'table' click it.
-
can't see any table option after clicking insert?
-
OK highlight it and press ctrl+t
-
Sorry I meant forget the insert and table bit and just highlight the info and push ctrl+t
-
How did you get on? If you want I will send you an example of how I do mine, I'll just need your email.
-
I still haven't been able to do this. Can anyone tell me how to turn my bank download into a table and then add another column that i can check off- thus leaving only the unassigned items.
Also what does search by tag mean in wcp, and how do you do that?
-
By no means am I suggesting you are a dummie ;D
http://www.dummies.com/how-to/content/how-to-create-a-table-in-excel-2007.html
-
Still struggling. I've found the table command, it comes under the data button, but it then asks me to input a row and a column value, but my attempts have been invalid.
My version of excel is 2007 for mac.
even when i've done it i don't know how to add a checkbox column.
-
A Mac? Oh...... there may be variations between PC and Mac versions of excel 2007
If you click the insert tab at the top (where it says Home, Insert Page, layout etc) what is there?
-
cell- Row- column -chart- list- sheet- page break -function
The table command is under something called data, but a window pops up and asks for a row and a column cell.
-
Try putting in the box the top left cell of your data i.e A1 then : then the bottom right cell say its H90 so you get A1:H90
If you are still struggling I could send you a table.
If you send me an email I will reply to you with a table. You can then copy your data and paste it into the table.
-
you can take your email down. thanks for that