Matching transactions (reconciling) using Excel Pivot Tables | ExcelTutorials

Matching transactions (reconciling) using Excel Pivot Tables | ExcelTutorials

Learn how to reconcile (or match) transactions using Excel Pivot Tables. Example workbook and more here:

Do Subscribe, Like & Share my video if you like!!

Click The Below Link To SUBSCRIBE:

[jordanhanson]

I know this video is a bit old. But that formula in the end column is going to help out a lot. Thank you.

[mrsgodoy]

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?

[simitmishra]

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?

[nagendravarma]

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.

[cheilaandrade]

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 :(

[bethanytrapp]

I have been trying to figure out how to hide the minuscule 0 values all day! Thank you!

[mlw]

Both solutions are excellent, but I must say I love the first, better for my finance department!

[MrKiru]

Great one.. tnx for dat..
Wt if we are still okay to match if difference is 0.5 or 1.. within Vendor reconciliation??

[pavika]

How can I match up the invoices with multiple currencies using the physical invoices

[paulhan]

Why didn't you explain the Round formula more in details?? What's going on?

[micamrc]

excuse me.. you just showed and hided the formula, it did not show how you write formula like other tutorials !!!

[omkarnaidu]

If vendor details not available and just have to netoff the amounts

[sumanbehera]

Hi could you please help me the same by different Journal description according different product wise...

[tejasaji]

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.

[KoolGuyism]

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..

[mmusic]

सर नमस्ते मेरे लिये ऐसि भिडियो बनादिजिये
how to find pairs for credit and debit in excel

[gkandvoicebysufi]

Sir please tech us amazon payment recancelation

[indracanti]

Sir if vendor reference not given in received amounts. Then how to reconcile. Please revert

[asianking]

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?

[aijazhussain]

You have not explained formula first you must explain formula than u explain pivot table. Ok Sir