Reconcile Quickbooks Company Income/invoices and Bank statements 2017-2019

취소 완료 등록 시간: 3년 전 착불
취소 완료 착불

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?

회계 부기 인튜잇 퀵북스 Xero MYOB

프로젝트 ID: #25480537

프로젝트 소개

48 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 3년 전

수상자:

melvinfabianjr

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 기타

$40 USD (7일 이내)
(4건의 리뷰)
2.9

이 일자리에 대한 프리랜서 48 명의 평균 입찰가: $469

smartbookaccount

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

$700 USD (5일 이내)
(40 리뷰)
5.2
dheerajjshetty19

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 기타

$250 USD (1일 이내)
(27 리뷰)
4.9
miansajid3000

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

$750 USD (15일 이내)
(25 리뷰)
5.1
cro0459030

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 기타

$300 USD (5일 이내)
(25 리뷰)
3.9
LopezPerlitaP

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 기타

$500 USD (7일 이내)
(1 리뷰)
1.8
Raheelahmed05

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 기타

$333 USD (10일 이내)
(3 리뷰)
1.9
shakimkpo

Dear Sir, Regarding your posting on freelancers towards Quickbooks job, I wish to apply the same. We are Certified QuickBooks ProAdvisor from India. I will make this project successful because I have vast experience 기타

$500 USD (7일 이내)
(2 리뷰)
1.3
Riddhvik

Dear Sir, I am a Chartered Accountant with a handsome experience of more than 7 years in Accounting, Payroll and Preparation of Financial Statements. Since 2015, I am an Intuit certified Quickbooks Pro-Advisor as well. 기타

$500 USD (7일 이내)
(2 리뷰)
1.5
camcruz031897

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 기타

$350 USD (1일 이내)
(2 리뷰)
1.2
munibakh8

Hey, I read your work requirement with great interest and want to work on your project. I have more than 6 years of experience in the field of Accounting and finance. Expert in quick book and other software as well. 기타

$289 USD (7일 이내)
(0 리뷰)
0.0
Awasif9497

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 기타

$278 USD (7일 이내)
(0 리뷰)
0.0
jeesto177

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

$333 USD (7일 이내)
(0 리뷰)
0.0
regsaccounting

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 기타

$250 USD (7일 이내)
(1 리뷰)
0.0
ethelcmartinez

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.

$500 USD (7일 이내)
(0 리뷰)
0.0
madhukeshi4

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 기타

$500 USD (7일 이내)
(0 리뷰)
0.0
suviniErandi

Having 3.6 years about QB with Audit Firm Experienced and also with Commercial Experience with Proffercial Experience about accounting.

$500 USD (2일 이내)
(0 리뷰)
0.0
laxmimrudhula

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

$444 USD (5일 이내)
(0 리뷰)
0.0
tejal13gugale

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

$556 USD (1일 이내)
(0 리뷰)
0.0
Nikhilsbohra

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 기타

$500 USD (7일 이내)
(0 리뷰)
0.0
cashubhmkatiyar

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 기타

$411 USD (6일 이내)
(0 리뷰)
0.0