I need some help with finding an accountant who is proficient in excel and QuickBooks (or any other reconciliation software you can use to create monthly credit card reconciliations for 2018 (just like the bank).
Credit card reconciliation project:
DUE IN THE NEXT COUPLE HOURS! WILL COMPENSATE FOR EXPEDITED DELIVERY!
I did the QBO to Bank checking account reconciliation, which is attached. I need someone who is proficient in QuickBooks Online and Excel to help me with the credit card side. See the file attached. The "Checking from Chase" and "Checking from QBO" tab show how I was handling the comparison. Please follow the formulas and see that there are a couple transactions to look into, but they don't change the overall balance for the year. I'd like this is to be the same for the Credit Card side. The "CC from Chase" file should have all the credit card transactions from our bank. In the "CC from QBO" tab, you will compare to the “CC from Chase tab” as I did for checking.
The full 2018 transaction list in Chase for 2018 is listed by account in the "Full transaction list QBO" file. Look at this and ensure it ties out each month. Add notes if anything is different so it’s clear and concise. Put these next to the transaction and also have a Summary sheet with all notes in chronological order (Jan to Dec).
Finally, once reconciled in Excel, go into Quickbooks Online and simply complete the reconciliations for each month. There will be 12 PDF’s to print, which will be each month. Final deliverable will be a zip file with a folder “2018 Credit Card to QuickBooks Online Reconciliations”. Within that folder there will be 12 folders labeled, “1-Jan”, “2-Feb”,...”12-Dec”. Within each folder please save a PDF of the reconciliation done in QuickBooks, the excel file showing the matching transactions and balance but only for that month. So each month will have a different excel workbook. Also, either highlight or note the ending balance on the QBO Reconciliation and the Excel Balance. These should be the exact same and makes it easy to audit. Lastly, also save the PDF version of the Bank Statement for that month.
Finally, add a “All” folder for the full annual workbook, PDF with 12 pages in one document for each rec, and then one PDF for all bank statements in order. Ensure that the ending balances are clearly shown to be the same for a high level check.
Since I already have the workbook setup with all the data, it shouldn’t take long. I expect one hour but if it takes longer I’m very fair and will compensate you appropriately.
Hopefully this goes well as I’m looking for a long-term, reliable person. Potential for many large projects. Just an FYI if interested.
**ONE IMPORTANT NOTE: THIS MUST BE DONE TONIGHT AKA ASAP. IF YOU CANT COMPLETE IN THE NEXT 4 HOURS PLEASE NOT APPLY**
Pleasure to help you. I can handle well accounting job using Quickbooks. Willing to help your reconciliation. Feel free to message me to start the job. Thank you so much.