Bank Statement to QuickBooks for Third-Party Logistics: Convert PDF Statements to QBO

A fulfillment operation earns money in several distinct ways, and lumping them into one Sales account hides which service actually pays. Split your income so you can see each one: receiving fees for taking product in off the truck, storage or warehousing fees billed per pallet or per bin per month, pick-and-pack fees charged per order or per item, kitting and assembly work, returns processing, and any account minimum or flat monthly fee. When these sit in separate accounts you can look at a report and tell whether storage is subsidizing thin pick-and-pack margins, or the other way around. That visibility is worth the few extra lines in your chart of accounts.

Here is the big one. A 3PL buys UPS, FedEx, and USPS labels and then bills those labels back to clients, sometimes at cost and sometimes with a markup. How you record it matters. You can report the reimbursement as revenue and the carrier cost as cost of goods sold, which is the gross method, or you can net the two so only your margin shows. Which is correct depends on whether you control the shipping service under the principal-versus-agent test in ASC 606. Most 3PLs that buy the label in their own carrier account and set the price their clients pay are acting as principal and report gross. This is a judgment call with real tax and revenue implications, so confirm your facts with a CPA. Our guide to recording commission income walks through the same principal-versus-agent reasoning if you want the longer version.

This is the mistake to avoid, and it is a common one. The goods you store and ship belong to your clients, not to you. That arrangement is a bailment: you hold the property, but you never take title to it. Client inventory does not go on your balance sheet as inventory, ever, no matter how much of it is sitting in your racks. The only inventory or supplies you carry are your own: boxes, dunnage, tape, void fill, labels, and pallets you buy to do the work. Those are a supplies or packaging expense. Putting client goods on your books overstates your assets and creates a mess at tax time, so keep the line clean.

3PLs almost always invoice clients monthly on net terms, so the cash arrives well after the work is done. That gap is exactly what accounts receivable is for. Record the invoice when you bill it and match the client payment against it when it hits the bank weeks later, rather than booking revenue only when cash lands. Setup and onboarding fees show up when you take on a new account, and refundable security deposits appear too. A refundable deposit is a liability, not income, because you may have to give it back. When clients pay by card or ACH, you will also see merchant and processing fees come out; those are an expense and belong in their own account.

Modern fulfillment runs on a warehouse management system. Subscriptions to platforms like Extensiv (3PL Central), ShipHero, or Logiwa are a software expense, as are the billing engines that turn your activity into client invoices. EDI connections and the integration or middleware costs that tie your WMS to client shopping carts and marketplaces belong in the same neighborhood. These recurring charges are easy to spot on a card statement and easy to miscategorize as miscellaneous, so give software its own account and let it show its true monthly cost.

Forklifts, pallet racking, conveyors, and packing stations are depreciable fixed assets, not expenses you write off in the month you buy them. When you finance or lease equipment, which is common in this industry, split each payment into principal and interest so your loan balance and interest expense both stay accurate. Warehouse rent and utilities are usually your largest fixed costs. If you operate more than one building, use QuickBooks classes to tag each transaction by warehouse so you can see the profit and loss for each location separately. That is often the difference between knowing a site is losing money and finding out a year too late.

When client goods are lost or damaged on your watch, the resulting claim or chargeback is an expense or a liability. Do not net it against revenue, because that hides both the true cost of the incident and your real top line. Labor is the other big number. Warehouse payroll is straightforward, but many 3PLs flex up with temp workers. Temp labor billed through a staffing agency is simply an expense on their invoice. If you pay individuals directly as 1099 contractors, track those payments for reporting: the threshold is $2,000 for payments made on or after January 1, 2026, and it is indexed for inflation after that. Confirm the specifics with a CPA before filing.

How do I record 3PL fulfillment revenue in QuickBooks?

Split it by service line rather than booking one Sales figure. Create separate income accounts for receiving, storage, pick-and-pack, kitting, returns processing, and account minimums, then invoice clients on their monthly terms and post each payment against the open invoice. That structure shows which service earns its keep and keeps your accounts receivable accurate.

How do 3PLs account for pass-through shipping costs?

It depends on whether you control the shipping service under the principal-versus-agent test in ASC 606. Most 3PLs that buy labels in their own carrier account and set the client price report gross: the billed-back amount is revenue and the carrier cost is COGS. If you are only an agent, you net the two. Confirm your position with a CPA.

Do I put client inventory on my 3PL balance sheet?

No. Goods you store and ship for clients belong to them, not to you. That is a bailment, and titled property never becomes your inventory or your asset. Only your own supplies, meaning boxes, tape, dunnage, and pallets you purchase, belong on your books, and those are an expense, not client inventory.

How do I record carrier shipping charges in QuickBooks?

Post the label charge from UPS, FedEx, or USPS to a shipping cost of goods sold account when you report gross. Then record the amount you bill the client back as shipping income. Keeping the cost and the reimbursement in separate accounts lets you see whether your shipping markup is actually covering the freight you buy.

What chart of accounts should a 3PL use?

Build income accounts for each service (receiving, storage, pick-and-pack, kitting, returns, minimums, and shipping), and expense accounts for carrier labels, packaging supplies, WMS software, rent, utilities, payroll, temp labor, and processing fees. Add fixed asset accounts for forklifts and racking, plus liability accounts for refundable deposits. Use classes to separate multiple warehouses.

How do I import a bank statement into QuickBooks?

First convert the PDF statement to a .qbo file with the converter at the top of this page, since QuickBooks cannot read a PDF. In QuickBooks Desktop, go to File > Utilities > Import > Web Connect Files and select the .qbo. In QuickBooks Online, go to Transactions > Bank transactions > Upload from file, then match the transactions to your accounts and reconcile.