Suoritettu

Credit card reconciliation project setup to be completed in excel and also reconciled in QuickBooks (just like a monthly bank reconciliation) for 2018. **DUE BEFORE TOMORROW MORNING**

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

Taidot: kirjanpito, ERP, Excel

Näytä lisää: quickbooks credit card reconciliation problem, how to reconcile in quickbooks online, how to reconcile credit card in quickbooks online, how to re-reconcile in quickbooks, quickbooks reconciliation discrepancy, quickbooks credit card reconciliation beginning balance, how to reconcile credit card in quickbooks desktop, quickbooks bank reconciliation problems, integrate bank americas credit card gateway, reconcile bank credit card projects, monthly bank statement form, bank generate virtual credit card, credit bank usa admin demo login password, credit bank admin demo login password, bank credit card payment virtuemart payment module, askari bank department credit administration, cashback credit ebates mrrebate fatwallet cashbaq bing bigcrumbs kickitback bank movie greenbackstreet, credit comision bank post admin demo login password, hansa bank credit card authorization, worker monthly salary payment sheet sample ms excel

Tietoa työnantajasta:
( 2 arvostelua ) NEW YORK, United States

Projektin tunnus: #18591173

Myönnetty käyttäjälle:

renesontiongson

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.

$30 USD 1 päivässä
(78 Arvostelua)
5.7
APSJASSOCIATES

Hello Sir/Madam I would like to represent myself for the job opportunity being offered by you. I'm chartered accountant Abhishek Sachdeva & I have been in the field of accounts & finance for the last 7 years. I can Lisää

$15 USD 0 päivässä
(3 Arvostelua)
1.6

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

madhurna

Greetings! I am qualified accountant and Certified QuickBooks ProAdvisor with ten years of experience. Please PM to discuss. Thank you.

$100 USD 1 päivässä
(86 arvostelua)
6.9
usmanhassan123

sir I can deliver you within next four hours. I have read your project description and I understand your requirements. With more then seven years of experience as a freelancer. I also have five years of experience o Lisää

$150 USD 1 päivässä
(66 arvostelua)
6.1
khurram1984

Hi. I am an Affiliate chartered accountant (CPA) and a professional finance expert since 2009. I have a firm established with requisite resources at my disposal. We are working with many clients including USA, Canada, Lisää

$85 USD 2 päivässä
(88 arvostelua)
6.0
$25 USD 1 päivässä
(0 arvostelua)
0.0
m83bandason

Hello sir I have read your project description and I can do your project up to the last detail. I have more than 10 years experience working in Banking and Service industries doing Crerical and administrative tasks. Lisää

$111 USD 1 päivässä
(0 arvostelua)
0.0
$25 USD 1 päivässä
(0 arvostelua)
0.0