Reconcile Quickbooks Company Income/invoices and Bank statements 2017-2019
$250-750 USD
착불
I need someone knowledgeable in accounting and Quickbooks and able to open a quickbooks desktop (enterprise) file to reconcile my 2017-2019 income and bank statements. I have about 95% of the transactions recorded however I find discrepancies in the total amounts compared with bank.
What I can provide are the following:
1-QB company file.
2-Reports from bank accounts showing credit deposits.
3-Sales reports from all payment processors (Paypal, Shopify etc.)
My method of recording transactions were the following:
-in 2017-2018, I was recording in Quickbooks all the sales on a monthly basis on one invoice (using inventory for different items sold). The income from the invoice is paid is paid to the specific payment processor account (e.g. paypal income account), then when I transfer money from PayPal to my bank account, I would make a transfer in QB from PayPal to Bank account. So the amount in the bank account and quickbooks were relatively accurate since not affected by mistakes in invoices.
- The balance on Paypal on the other hand on the Paypal-QB account was different from the balance on the actual PayPal account, due to some mistakes in invoices.
- Around 2019 I started recording those sales on an every other day basis (when I ship) so less mistakes happen, however I also used an additional sales channel and payment processor (shopify) which began depositing payouts directly to my bank account about every 2 days. This made it harder to have an accurate bank account balance in QB compared to the real bank account balance because now I was recording invoices being paid to an account in QB called Shopify payout account... at the end of the year I would run a report from my bank account and see what were the total deposits from Shopify and then transfer from Shopify Payout account in QB to my bank account in QB.
-On QuickBooks. I record all my bills including purchase orders for separate inventory items (I have about 50 different inventory items).
-I have multiple payment accounts I receive money through. 1-PayPal. 2. eBay Payments 3. Shopify Payments. In 2017-2018 it was only PayPal so it may be easier.
-I believe the invoices are about 95% accurate, in 2019 closer to 98% accurate because I ensure that the invoice I am recording in quickbooks for the last 2 days value equal to the total value of the shipped items (shipping software provides me that info to compare).
Challenges you may face:
I think the main problem you may face is reconciling single sales transactions with daily invoices which are recorded every other day that include transactions made for the whole previous days.
Also in the invoices some items are sold as a package... like for example an item called Bold-Black-Start for 15$.... will be three items. when I make an invoice for it I have three items in the invoice, but only one will have the total of 15$ and the two other items will be total of 0$ and 0$.
The other problem you may face is recognizing the transactions that are actually refunds. Some times orders are placed and canceled before they are shipped so I do not record those at all. But one of my sales income reports of one of the 3 sales channels will include them. The way I check those is by sorting by customer name and removing the duplicate income and refunds within the same day.
I know my info in QB is pretty solid around 95%, I just want to make it more accurate.
You can come up with creative solutions, either do an actual daily reconciliation, or creating a reconciliation account to somehow reconcile the differences.
As you can see I am not a professional accountant and was learning in the beginning as I go... now I need to get my accounting straight so I am open to suggestions.
Total about 30 transactions per day since 2017.
To prove you read the project and not auto-responder respond to the question:
How will you solve the problem of reconciling my PayPal QB with my real PayPal account if my qb invoices have minor mistakes?
프로젝트 ID: #25480537
프로젝트 소개
수상자:
Hello,\r\n\r\nThis job is something i am very capable as i have been an accountant for 5 years now and i can definitely help you reconcile your Quickbooks accounts. I am reliable, keen to details and fast learner. I wo 기타
이 일자리에 대한 프리랜서 48 명의 평균 입찰가: $469
I am a certified ProAdvisor in QuickBooks... Dear Sir/Madam, I trust you are well, I am a qualified accountant and an expert in QuickBooks over six years. feel free to discuss with me. Many thanks, Kajee
Hi, I have come across your post and would like to offer my services. A bit about myself, my academic qualification is Chartered accountant. For the past seven years I have gained considerable experience using various 기타
*I will matched the receipts of QB with real Paypal account. I have large experience in reconciliation as you can see my major previous projects are related to reconciliation and Paypal shopify Ebay and amazon was the 기타
Hello Client, I am a Certified Accountant (CPA & CA). I have more than 5 years of experience in Accounting, Finance and Tax Domain. I have been working for 5 years with global companies. I am Certified in Quickbooks 기타
My QB Project Response Hey, how's your business with the pandemic around? I find your job post very interesting. I am really into audit. This is actually my expertise because I have been in accounting and auditing in m 기타
Hi, Greetings i have read carefully all the scenario and your problems. the question from is you how i can reconcile paypal qb account with paypal bank account. the solution for this is that reconciliation will be done 기타
Hi, okay :) I can reconcile your Quickbooks company Income/invoices and Bank statements of 2017-2019. I am a very detail-oriented person. I am ready to start this project right away. Let's talk to discuss further. Than 기타
Hi, I reach out to this project and become to know that i have good knowledge of accounting so i can finish this confidential work and as per your requirements. You can share your work so i will start immediately to h 기타
I am University lecturer, and I am well experienced about Accounting and Finance. Now I am doing my PHD program, hence within 7 days i will finish your work. Thank you
Hi I am Renato G. Salicsic a Certified Public Accountant (CPA) Phils and Certified Management Accountant (CMA) Australia, having more than 18 years of experience in accounting and financial management. Services offered 기타
I have experience working with quickbooks and working with this kind of analysis. I am sure I can help you to find all the dIscrepancies in your books.
Dear Sir/Madam, Before my Expertise and Experience in Accounting, I will provide the answer and my view on the Question. So to solve the Minor mistakes you are referring , my approach will be checking on Paypal Sales 기타
Having 3.6 years about QB with Audit Firm Experienced and also with Commercial Experience with Proffercial Experience about accounting.
Hi, I have 10yrs experience in Quickbooks bookkeeping, Reconciliations, etc. I can finish the task in 5days. Please reach me if you are interested. Thanks, Mrudula.M
I m persuing CA course.. M in the final year.. I have a great expertise in book keeping and managing bank statements.. I am working in a CA firm since last 5 years..
Hello, I am Chartered Accountant with specialization in book keeping and accounting advisory with EY India for 3+ years in assurance practice. I completely understand you needs and I am happy to inform that I can ass 기타
Hi I am a Chartered Accountant, Practising in similar area, related to which the work is sought from your side and I think I will be the best person to deliver the same as I am having experience of more than 6 Years. W 기타