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

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?

Evner: Regnskab, Bogholderi, Intuit QuickBooks, Xero, MYOB

Se mere: create bank statements, example template bank statements, data entry paper bank statements, converting pdf bank statements excel, creating bank statements, bank statements online, companies create bank statements, quickbooks 2009 import invoices, scanning bank statements quickbooks, scan bank statements quickbooks, input bank statements quickbooks, quickbooks online bank statements, enter bank statements quickbooks, link bank statements quickbooks online, import bank statements into quickbooks desktop

Om arbejdsgiveren:
( 10 bedømmelser ) San Diego, United States

Projekt ID: #25480537

Tildelt til:


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 Flere

$40 USD in 7 dage
(4 bedømmelser)

48 freelancere byder i gennemsnit $469 timen for dette job


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 in 5 dage
(40 bedømmelser)

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

$750 USD in 15 dage
(25 bedømmelser)


$660 USD in 6 dage
(27 bedømmelser)

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 Flere

$250 USD på 1 dag
(27 bedømmelser)

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 Flere

$300 USD in 5 dage
(25 bedømmelser)
(3 bedømmelser)

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 Flere

$333 USD in 10 dage
(3 bedømmelser)

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 Flere

$500 USD in 7 dage
(1 bedømmelse)

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

$500 USD in 7 dage
(2 bedømmelser)

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 Flere

$350 USD på 1 dag
(2 bedømmelser)

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 Flere

$500 USD in 7 dage
(2 bedømmelser)

Having ten years of experience in Accounting,Book Keeping and Taxation with many accounting software expertise like Quick book. tally ERP and customized ERP’s . Can handle all types of accounting data . Sale invoicing Flere

$722 USD in 30 dage
(1 bedømmelse)

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

$289 USD in 7 dage
(0 bedømmelser)

I’m an accountant based in Shanghai with over 10-year over-all accounting experience for SMEs. Regarding your current problem, my thought is to figure out the discrepancies by sorting the results with periods. But I Flere

$250 USD in 7 dage
(0 bedømmelser)

I am a practicing professional member of Institute of Chartered Accountants of India (ICAI). ICAI is the only licensing cum regulating body of the financial audit and accountancy profession in India. I have over 10 yea Flere

$700 USD in 7 dage
(0 bedømmelser)

I am a part qualified Chartered Accountant I am sure that I can deliver your work on time and with great quality.

$333 USD in 5 dage
(0 bedømmelser)

I am CA student and have done articleship of 3 years.

$278 USD in 10 dage
(0 bedømmelser)

Greetings, hope everything is well with you. My name is Arslan having 5 years international experience in UAE in accounting . I am pleased to help you in this matter as my current company facing the same situation befo Flere

$667 USD in 30 dage
(0 bedømmelser)

I'll check each item entered in Quickbooks and compare it to the numbers in Paypal to check that amounts are properly entered. That way, we can track which item was incorrectly entered and correct it.

$300 USD in 15 dage
(0 bedømmelser)

Hi, For me to do the reconciliation of Paypal account to your Quickbooks, you provide me the Paypal statements for all the years.

$623 USD in 7 dage
(0 bedømmelser)