which accounting software used, how to start and performed reconciliation on my existing company. What are major points for reconciliation. Excel - Vlookup and Pivot table etc.

Question

Accepted Answer

I have experience using various accounting software and Excel tools like Vlookup and Pivot table for reconciliation.

I have used QuickBooks, Xero, and Wave accounting software for reconciliation.
To start reconciliation, I ensure that all transactions are recorded accurately in the accounting software.
I compare the bank statement with the accounting software to identify any discrepancies.
I use Excel tools like Vlookup and Pivot table to match transactions and identify errors.
Major points for reconciliation include matching opening and closing balances, ensuring all transactions are recorded, and identifying and correcting errors.
For example, if there is a discrepancy in the opening balance, I check for any unrecorded transactions or errors in the previous reconciliation.
I also ensure that all transactions are categorized correctly and any outstanding checks or deposits are accounted for.
Finally, I prepare a reconciliation report to document the process and any adjustments made.

which accounting software used, how to start and performed reconciliation on my existing company. What are major points for reconciliation. Excel - Vlookup and Pivot table etc.

Top HR questions asked in International Game Technology Financial Analyst 3