[masa_inn]

I am used to do it with vlookup, which is not ideal (one-way match unless you have two formulas, problems with repeated entries), but worked fine until I had multiple accounts added to the recon.

What do you use to reconcile in Excel? Pivot tables?

I understand my question is way too general, but I would appreciate some ideas.

FAR
AUD 02/10/14 passed
BEC
REG

Roger, WTB, Ninja materials

[005]

Quickbooks Accountant

BEC - ✔
REG - ✔
AUD - ✔
FAR - 11/29/14

CPAExcel, Ninja MCQs, and a sh*t ton of coffee

[005]

Quickbooks Accountant

BEC - ✔
REG - ✔
AUD - ✔
FAR - 11/29/14

CPAExcel, Ninja MCQs, and a sh*t ton of coffee

[masa_inn]

@005 nope, not going to work in my case

FAR
AUD 02/10/14 passed
BEC
REG

Roger, WTB, Ninja materials

[masa_inn]

@005 nope, not going to work in my case

FAR
AUD 02/10/14 passed
BEC
REG

Roger, WTB, Ninja materials

[teeteenounouche]

You can use the pivot to group the repeated entries and then do a vlookup on your pivot. Not sure if this is answering your question without more information.

Florida:
AUD: 73, 81! Thank you Lord!
BEC: 73, 77! Thank you Lord! and WTB
REG: 71, 82! Thank you Lord! and A71
FAR: 72, 78! Thank you God and my Mommy in Heaven!

CPA Excel, Ninja Notes & Audio, Wiley Test Bank, CPAreviewforfree

[teeteenounouche]

You can use the pivot to group the repeated entries and then do a vlookup on your pivot. Not sure if this is answering your question without more information.

Florida:
AUD: 73, 81! Thank you Lord!
BEC: 73, 77! Thank you Lord! and WTB
REG: 71, 82! Thank you Lord! and A71
FAR: 72, 78! Thank you God and my Mommy in Heaven!

CPA Excel, Ninja Notes & Audio, Wiley Test Bank, CPAreviewforfree

[masa_inn]

@teeteenounouche – yep, thank you

FAR
AUD 02/10/14 passed
BEC
REG

Roger, WTB, Ninja materials

[masa_inn]

@teeteenounouche – yep, thank you

FAR
AUD 02/10/14 passed
BEC
REG

Roger, WTB, Ninja materials

[teeteenounouche]

Glad it helped, you can also do a vlookup the opposite way to see the entries/accounts that are not included in your recon. They may need to be added or reclassed to the appropriate account.

Florida:
AUD: 73, 81! Thank you Lord!
BEC: 73, 77! Thank you Lord! and WTB
REG: 71, 82! Thank you Lord! and A71
FAR: 72, 78! Thank you God and my Mommy in Heaven!

CPA Excel, Ninja Notes & Audio, Wiley Test Bank, CPAreviewforfree

[teeteenounouche]

Glad it helped, you can also do a vlookup the opposite way to see the entries/accounts that are not included in your recon. They may need to be added or reclassed to the appropriate account.

Florida:
AUD: 73, 81! Thank you Lord!
BEC: 73, 77! Thank you Lord! and WTB
REG: 71, 82! Thank you Lord! and A71
FAR: 72, 78! Thank you God and my Mommy in Heaven!

CPA Excel, Ninja Notes & Audio, Wiley Test Bank, CPAreviewforfree

[Author]

Replies