Matching transactions (reconciling) using Excel Pivot Tables | ExcelTutorials
ฝัง
- เผยแพร่เมื่อ 8 มิ.ย. 2014
- Matching transactions (reconciling) using Excel Pivot Tables | ExcelTutorials
Learn how to reconcile (or match) transactions using Excel Pivot Tables. Example workbook and more here:
chandoo.org/wp/2014/06/10/matc...
Do Subscribe, Like & Share my video if you like!!
Click The Below Link To SUBSCRIBE:
/ @chandoo_
![How to Pivot text values in Excel [Simple Trick]](http://i.ytimg.com/vi/iZo5k_L8_RI/mqdefault.jpg)
![How to Pivot text values in Excel [Simple Trick]](/img/tr.png)
I know this video is a bit old. But that formula in the end column is going to help out a lot. Thank you.
This is great that you shared this. I have been using this for many years and its disappointing that many accountant don't utilize this approach. I do have a question when it involves rows that exceeds Excels limit of approx 1 million. How would you utilize the sumifs approach when the dataset if too large?
I have been trying to figure out how to hide the minuscule 0 values all day! Thank you!
😂
Your job is great! Thank you. I have a question on top of it. What if I do not have a criteria such as vendors just the unmatched numbers? What can I do? I am desesperated for that :(
I Like this one, Thanks
Chandoo ji great efforts. Going a bit further with concept, How can we compare two data columns to spot changes that have been made in the same sheet afterwards using this pivot table function?
Lifesaver!! Thanks so much!
Both solutions are excellent, but I must say I love the first, better for my finance department!
Excel2013 recognises @.. but it is smarter to replace it with just the column.. e.g i used =SUMIFS([id],[name],@[[name]]) but excel 2013 automatically changed it to =SUMIFS([id],[name],[name]) without throwing any error.
I am sure you have defined the range as table, but inc ase not then you may try after format the data as table.
Im using 2010 will it work. Its throwing error. Please help. I took the same data. Am i need to change the data to table.
Im using 2010 will it work. Its throwing error. Please help. I took the same data. Am i need to change the data to table.
Great one.. tnx for dat..
Wt if we are still okay to match if difference is 0.5 or 1.. within Vendor reconciliation??
The POWER of PIVOT TABLES!
Im using 2010 will it work. Its throwing error. Please help. I took the same data. Am i need to change the data to table.
Great video!
Excel guru 👍
thank you sir
Thanks!
Thank u so much big help
Always welcome
Brilliant Video
Im using 2010 will it work. Its throwing error. Please help. I took the same data. Am i need to change the data to table.
How can I match up the invoices with multiple currencies using the physical invoices
Hi, I want to perform a one to one trade reconciliation between two files. how would i do it when i do not have any common reference in both the files..? Also please note that i want to reconcile multiple fields like trade date, quantity, price etc..
Sachin Sharma did u find a way to perform this kind of reconciliation pls, as I have to deal with the same kind of reconciliation, kindly.
I think the solution would be to create a helper column by merging the cells that you need to do a matching against in both list.
once you started speaking here, I got remembered the voice of south African senior most cricket commentator mike haysman. please try to listen to his voice once.
Wow.. that is great to hear. I just heard him in a video 😀
good video, though i think vendor is incorrect here instead customer could be the appropriate use of word; as we need to received the amounts.
Hi could you please help me the same by different Journal description according different product wise...
Can you share some data about this problem?
@@chandoo_ hi chandoo thanks for replying...sure I can but may I know your personal or business email adress so I could share
Sir please tech us amazon payment recancelation
🙏
If vendor details not available and just have to netoff the amounts
excuse me.. you just showed and hided the formula, it did not show how you write formula like other tutorials !!!
Why didn't you explain the Round formula more in details?? What's going on?
6:46
सर नमस्ते मेरे लिये ऐसि भिडियो बनादिजिये
how to find pairs for credit and debit in excel
Good idea. I will try.
Sir if vendor reference not given in received amounts. Then how to reconcile. Please revert
th-cam.com/video/AoA9-hq77MM/w-d-xo.html
see the above you will get clear idea how to do reconciliation in pivot
You have not explained formula first you must explain formula than u explain pivot table. Ok Sir
Chandoo i work for delioitte
This is good
But lets say
We have a customer
John
And
Gabby
How will this know what number we are matching ? As in maybe john has +100
And gabby has -100
This will match that but matching the wrong customer transanctions?