Petroleum Accounting & Financial Management

Accounting built
for cents per gallon,
not general ledger.

BookWorks Petroleum Accounting is a fully integrated GL, AR, and AP platform engineered around the unique financial reality of fuel distribution — where fractions of a cent per gallon determine whether the month is profitable, and where generic accounting software simply wasn't designed to keep up.

Fully Integrated GL / AR / APTreasury Management & BAINet Margin MonitoringReport-to-Transaction Drill-Down
BookWorks — Financial Dashboard✓ GL Balanced
Net Margin / Gal
$0.0698
↑ +$0.0031 vs prior mo.
AR Outstanding
$2.41M
94.2% current
AP Due This Week
$847k
3 invoices past due
AccountDebitCreditBalance
1200 · Accounts Receivable Asset$2,412,840$2,412,840
2100 · Accounts Payable Liability$1,284,100($1,284,100)
4000 · Fuel Sales Revenue Revenue$8,241,600($8,241,600)
5000 · Cost of Fuel Sold COGS$7,935,200$7,935,200
AR Aging
Current
$2.27M
31–60
$112k
61–90
$29k
EFT Batch — Today
Sunoco Supply$340,200Sent
Gulf Coast Terminal$218,400Sent
Enviva Propane$84,700Pending
3
Fully integrated modules —
GL, AR, and AP
32+
States with native motor
fuel tax reporting
100%
Petroleum-specific — not
generic accounting adapted
30+
Years of petroleum
accounting refinement
Why Petroleum Accounting Is Different

General accounting
software was never
built for this.

QuickBooks tracks debits and credits. BookWorks tracks debits, credits, rack prices, terminal fees, freight, state excise taxes, consignment inventory, customer rebates, and supplier discounts — and shows you your true net margin per gallon, per product, per customer, per day.

See how it works in a live demo
Cost margin monitoring at every transaction

Every order, shipment, and invoice updates your margin position in real time — alerting you when a customer contract or zone is bleeding below your threshold before the month closes.

🔗
Accounting is native to operations — not connected

In BookWorks, a dispatched delivery automatically creates the shipment, updates inventory, and generates the invoice. AP invoices from supplier portals post directly to the GL. Nothing falls through a gap between two systems.

🔍
Drill from summary to transaction in one click

Any figure on any report — AR balance, margin total, daily sales, AP aging — can be drilled through to the underlying transaction. No re-running reports, no cross-referencing spreadsheets.

Capability
BookWorks
QuickBooks / Generic
Petroleum-native GL structure
Must be configured
Cost margin per gallon tracking
Real-time
Not available
Motor fuel tax reporting
32+ states
Requires add-on
Supplier portal AP integration
Native
Manual entry
EFT / NACHA ACH payments
Multi-format
Limited
Consignment inventory accounting
Not available
Net margin (incl. rebates & discounts)
New
Manual calculation

See all three modules working together in one demo

Book Demo →
Accounts Receivable

Every dollar owed,
tracked to the cent.

BookWorks AR is built for the high-volume, low-margin reality of fuel distribution — where you're billing hundreds of accounts weekly, managing aging across multiple customer types, and collecting via draft, EFT, and check simultaneously.

AR Draft Process with Payment Discounts NewThe AR draft process now supports payment discounts — enabling early-pay discount programs without manual credit memos.
AR Statement Formats 11, 13, 15, 16, 99Multiple statement formats including Open Item (Format 99) with aging buckets, last invoice, and last payment info. Formats 15 and 16 aligned for #10 envelope specs.
Digital Statements NewStatements are automatically delivered to customers digitally — sent directly to their email address and pushed to their MobileConnect account. Customers see current balances and aging detail without a paper statement or phone call, reducing inbound AR inquiries and accelerating payment.
Segmented Draft Summary UpdatedThe segmented draft summary with payment product summary is fixed and fully functional — including email delivery.
Credit Limit ManagementConfigurable credit limit warnings at dispatch — choose to warn, block, or allow with override. Prevent over-extending credit without stopping your operation.
Receivables Recap with Opening & Closing Balances RestoredBeginning and ending AR balances restored to Balance Forward and Transactions summary reports — essential for period-end reconciliation.
QR Code Invoices to Customer PortalEvery invoice includes a QR code that takes customers directly to their WebConnect portal for self-service payment — reducing AR collection time.
Posted Payment Safeguard NewPosted payments are now protected from editing — preventing accidental modifications to cleared transactions that would corrupt reconciliation.
Salesman / Driver / Commission ReportsOriginal purchase date (first purchase by customer) added to Sales Summary by Salesman/Driver/Commission — enabling true customer lifetime analysis.
Lockbox BankingIncrease cash flow and eliminate staff time managing checks by electronically capturing payments near real-time through lockbox banking. Checks are deposited and processed automatically — BookWorks auto-posts the payment against the corresponding customer receivable, keeping your AR current without manual reconciliation.
AR Aging — Statement Format 99$2,412,840 total
CustomerCurrent31–60 Days
Acme Distribution
Last inv: Jan 14 · Last pmt: Jan 10
$84,200
Valley Fuel Partners
Last inv: Jan 12 · Last pmt: Dec 28
$41,800$18,400
Crown Energy Corp
Last inv: Jan 15 · Last pmt: Jan 15
$112,600
Tri-State Petroleum
Last inv: Dec 30 · Last pmt: Dec 5
$12,100$29,400
Total Outstanding
$2,270,600$141,240

Available AR Statement Formats

11
Standard Balance Forward
13
Itemized Open Items
15
#10 Envelope — Left
Updated
16
#10 Envelope — Right
Updated
99
Open Item with Aging Buckets
New Data
+
Custom formats available
Accounts Payable

Pay suppliers
accurately, on time,
automatically.

Supplier payments in petroleum wholesale move fast — terminal invoices, freight carriers, and tax authorities all require accurate, timely payment. BookWorks AP handles the entire cycle from invoice to cleared check or ACH, with the audit trail your auditors and your suppliers expect.

Reverse Single Invoice from AP Check NewSelect "R*" beside any invoice in an AP check or draft to reverse just that invoice — without voiding the entire check batch. A major time saver for multi-invoice supplier payments.
Purchase Clearing Tab NewThe Vendor screen now includes a Purchase Clearing tab showing all unassigned supplier receipts — making it immediately visible when terminal invoices haven't been matched to a purchase order.
AP Non-Supplier Batch Import FixedMultiple bugs in the AP non-supplier batch transaction import resolved — enabling bulk import of freight, carrier, and non-fuel AP invoices without errors.
Non-Supplier AP Invoice AutomationAutomate the ingestion of non-supplier AP invoices — freight carriers, utilities, service vendors, and other recurring payables — through Pulse AI document extraction or structured file import. Pulse reads PDF and email invoices and pushes them directly into BookWorks AP as structured records, eliminating manual entry for the invoices that fall outside your supplier workflow. High-volume operations can also use batch file ingestion for bulk AP population from any source that generates a structured export.
AP Check Style 3 — QB Top Check with MemoMemo notation from Vendor Comments now displayed on AP Check Style 3, ensuring payment notes flow through to the printed check.
60-Day AP Date Check (with Year)AP 60-day date validation now correctly includes the year component — prevents false warnings when invoices legitimately span a calendar year boundary.
AP Invoice Clearing Performance ImprovedSignificantly faster AP Invoice Clearing routine — reduces wait time when processing large batches of supplier invoices at terminal close.
Future-Dated Invoice WarningWarning message triggers when entering non-supplier invoices dated more than 60 days in the future — catches data entry errors before they post.
AP Check Run — January 2025✓ 14 Vendors Selected
Supplier Invoices — Terminal & Fuel
🏭
Sunoco LP — Terminal Invoice #T-8841
8,000 gal Diesel · BOL #84291 · Jan 14
$22,728
🏭
Gulf Coast Terminal — Inv #GC-4420
6,500 gal Gasoline · BOL #84292 · Jan 14
$17,017
Freight & Carrier Invoices
🚛
Regional Tanker Co. — Freight Jan 1–15
42 loads · Batch import · Matched
$18,900
Reversal — Single Invoice
↩️
Sunoco LP — Inv #T-8820 REVERSED
Price correction applied · R* selected
($1,240)
Total AP Check Run$58,405
NACHA ACH File Preview
CompanyName: "ACME PETROLEUM LLC"
SEC Code: CCD // Per-vendor setting
EffectiveDate: 250116
TotalDebit: $58,405.00
Format: Generic Bank NACHA ★ New
General Ledger & Journal Entries

A GL that speaks
petroleum.

The BookWorks General Ledger is structured around the natural chart of accounts for a petroleum distribution business — fuel inventory, terminal liabilities, excise tax payables, freight clearing, and consignment accounts all have their proper home without workaround configurations.

Recurring Journal Entries — CR Type FixedRecurring journal entries now support the CR transaction type — previously missing, causing period-end reclassification entries to require manual re-entry each month.
Consolidated Balance Sheet FixedThe Consolidated Balance Sheet report is fully operational — essential for multi-entity petroleum companies reviewing combined financial position.
GL Transaction Type ControlsCD-type GL transactions are properly excluded from AP Check testing — preventing false validation errors on cash disbursement entries.
Crystal Reports Drill-DownAny balance on any financial report drills through to the underlying journal entry, invoice, or transaction — full audit trail from summary to source document.
Excel Export on All Reports NewEvery GL, AR, and AP report now exports to Excel — enabling custom analysis, board reporting, and CPA-ready financial packages without manual reformatting.
Multi-Entity SupportManage multiple petroleum entities — separate companies, divisions, or subsidiaries — with consolidated reporting across all entities in a single BookWorks environment.
Trial Balance — January 2025
↓ Excel🔍 Drill
AccountDebitCreditBalance
1000Cash & Equivalents
$1,241,800$1,241,800
1200Accounts Receivable
$2,412,840$2,412,840
1400Fuel Inventory
$384,200$384,200
2100Accounts Payable
$1,284,100($1,284,100)
2300Excise Tax Payable
$218,400($218,400)
4000Fuel Sales Revenue
$8,241,600($8,241,600)
5000Cost of Fuel Sold
$7,935,200$7,935,200
Totals
$11,974,040$11,974,040$0.00
General Ledger BalancedLast posted: Today 9:42am · 847 transactions
Cost Margin Monitoring

Know your true margin
before the month ends.

In petroleum distribution, gross margin and net margin can look very different once customer rebates, supplier discounts, and volume incentives are factored in. BookWorks now tracks all three components — and shows you net margin per gallon, per customer, and per product.

📊
Net Margin Reports — now include rebates & discounts

New margin summary reports include customer rebates, discounts, and supplier discounts in the calculation — giving you true net margin, not just gross spread. Available for any date range with comparison filter.

Margin alerts on every transaction

Configure margin thresholds by customer, zone, or product. BookWorks flags any order, contract, or delivery where your realized margin falls below the threshold — before it ships, not after it posts.

📈
Comparison filter across periods

Run any margin report with a built-in comparison to a prior period or benchmark — measure whether January 2025 is trending better or worse than January 2024 without building a spreadsheet.

🔎
Drill from margin summary to cost detail

Any margin figure drills through to the underlying cost components — rack price, freight, terminal fees, taxes paid, and discounts applied — showing you exactly where margin was made or lost.

Gross Margin by Product — Jan 2025$0.0741 avg
Diesel #2
$0.0821
Gasoline
$0.0698
Heating Oil
$0.0512
Kerosene
$0.0341
Net Margin — After Rebates & DiscountsNew
Gross Margin
$0.0741
Per gallon avg
Customer Rebates
−$0.0082
Avg per gallon
Supplier Discounts
+$0.0039
Volume incentive
Net Margin
$0.0698
↑ $0.0031 vs. prior mo.
Treasury Management

Every bank. Every
format. Automated.

Paying suppliers electronically eliminates check printing, postage, and float risk. BookWorks supports multiple NACHA ACH file formats — recently expanded to include Generic Bank and Independent Bank formats — with per-vendor SEC code selection for maximum flexibility. Combined with BAI bank feeds, lockbox banking, and direct bank reconciliation, BookWorks manages your complete treasury relationship in one platform.

🏦
Generic Bank NACHA New

Full configurable format: ImmediateDestination, ImmediateOrigin, CompanyName, CompanyIdentification, OriginatingDFI — all fields configurable per your bank's requirements.

🏦
Independent Bank NACHA New

Dedicated NACHA format support for Independent Bank — one of the many regional bank formats added in recent releases to cover the full range of petroleum industry banking relationships.

🔀
Per-Vendor SEC Codes New

The AP NACHA file now supports different SEC codes per vendor — CCD, PPD, CTX as appropriate. Correctly handles suppliers, individuals, and government entities in a single batch file.

📁
1099K TXT File Upload New

New support for 1099K TXT file upload format — enabling electronic submission of 1099-K forms for payment card and third-party network transactions directly from BookWorks.

🏦
Bank Account Interfaces (BAI)

BookWorks native BAI integration connects directly to your bank — automatically importing bank transactions, posted checks, and ACH settlements for real-time bank reconciliation and transaction management.

🔐
Positive Pay

BookWorks supports positive pay — automatically generating and transmitting your issued check file to your bank so they can verify every check presented for payment against what BookWorks actually issued.

EFT Batch — ProcessingTransmitting
Batch Total$643,220
Vendor Payments
🏭
Sunoco LP
CCD · Routing: 021000089
$340,200Sent ✓
🏭
Gulf Coast Terminal
CCD · Routing: 063100277
$218,400Sent ✓
🚛
Regional Tanker Co.
PPD · Per-vendor SEC
$84,620Pending
Generated NACHA file
ImmediateDestination: 021000089
ImmediateOriginName: "ACME PETROLEUM"
CompanyID: 1841200049
SEC: CCD // per vendor
Format: Generic Bank ★ New
Reporting Library

Every report a petroleum
accountant actually needs.

BookWorks ships with a comprehensive library of petroleum accounting reports — all exportable to Excel, all drillable to the source transaction. For multi-company operations, BookWorks natively manages multiple entities and consolidates balance sheets and income statements into enterprise financial statement rollups — giving ownership a single view across all companies without manual spreadsheet consolidation.

📊

Margin Reports

Full suite of margin analysis — gross, net, by product, by customer, by period — with comparison filters.

Net Margin Summary incl. Rebates New
Margin by Customer with Comparison
Daily Totals with Margin Column New
Gross Sales Totals incl. Prebuy
Supplier Best Price Report
💳

AR Reports

Complete AR reporting from aging analysis to statement generation, commission tracking, and payment offset summaries.

AR Aging — Multiple Bucket Formats
AR Statement Formats 11/13/15/16/99
Receivables Recap — Opening/Closing
Sales by Salesman / Driver / Commission
Payment Offsets Summary by Location
🧾

AP Reports

Full AP visibility from open invoices through cleared payments, with purchase clearing and supplier reconciliation.

AP Invoice Aging by Vendor
Purchase Clearing — Unmatched Receipts New
AP Check Register & NACHA Log
1099 / 1099K Filing Reports
Vendor Payment History
📋

GL & Financial

Full financial statement package — trial balance, income statement, balance sheet, and enterprise consolidation across multiple companies. BookWorks natively manages multi-entity operations and rolls up balance sheets and income statements across all companies for ownership-level reporting.

Multi-Company Consolidation — Balance Sheet & Income Statemen
Trial Balance — Drillable
Consolidated Balance Sheet Fixed
Income Statement by Period
Journal Entry Detail & Summary
Recurring Journal Entry Schedule
🗺️

Tax Reports

Motor fuel tax reports for 32+ states — native government form output, updated with every regulatory change.

PA Carrier Report DMF-26 New
PA USTIF Throughput Report New
IN GT-103DR / MF-360 / SF-900 New
AL Hardship Tax — July 2025 New
VA, TN, GA, FL, and 25+ more states
📁

Export & Integration

Every report exports to Excel. Financial data integrates with Crystal Reports for custom CPA-ready financial packages.

Excel Export — All Reports New
Crystal Reports with Drill-Down
1099K TXT File Upload New
API Log for 3rd-Party Troubleshooting New
Custom Report Development Available
Compliance & Year-End

Year-end made
manageable.

From 1099 filing to motor fuel tax returns to audit-ready financials, BookWorks handles the compliance requirements that come with being a petroleum marketer — so your accountant doesn't have to reconstruct the year from spreadsheets.

1099 & 1099K FilingGenerate 1099 forms and upload 1099K TXT files electronically.
Motor Fuel Tax — 32+ StatesGovernment-form output updated with every regulatory change.
Audit TrailEvery transaction, every change, every posting — fully logged.
Consolidated FinancialsMulti-entity balance sheet and income statement reporting.
Posted Payment ProtectionCleared transactions are locked — no accidental reversals.
Crystal Reports PackageCPA-ready financials exportable in any format required.
Compliance Calendar — Current Status
🗂️1099 Filing — Tax Year 2024Ready
🗺️PA Carrier Report DMF-26 — JanNew Form
🗺️IN Consolidated MF-360 — JanNew Form
🗺️VA Motor Fuel Tax — JanReady
📊GL Trial Balance — January 2025Balanced ✓
📁1099K TXT Upload FormatNew
🏢Consolidated Balance SheetReady
Ready to See It Live?

Your books. Built for
petroleum.
Finally.

We'll walk you through a live demo of BookWorks Petroleum Accounting built around your business — your chart of accounts, your states, your billing programs. 30 minutes and you'll know whether it's the right fit.

Or email sales@keyinfotech.com · Birmingham, MI 48009

Schedule Your Demo
Personalized to your accounting needs and state requirements.

No obligation · Responds within 1 business day