Midland

FullOn scope

Overview

Monthly revenue$932.00
Fiscal year endDecember
Review cadenceMonthly 30 Minute Meetings

Contacts

3 people
  • Primary

Service brief

Xena is writing the brief…

Client Details

Related company name 1Water eStore USA
Related company name 2N/a
Home office %N/a
Monthly review meetingsMonthly 30 Minute Meetings

Service Items

  • Does the client use more than one currency?YesEntered on this record.
  • Does the client have intercompany loans?YesEntered on this record.
  • Does the client have payroll?YesFilled from Payroll workbook.
  • Does the client use classes in the books?YesEntered on this record.
  • Do we prepare the year-end package for the accountant?IncludedFilled from Bookkeeping scope.
  • Does the client have review meeting cadence?Monthly 30 Minute MeetingsIncludedFilled from Client Details.
  • Does the client claim a home office?NoEntered on this record.
  • Do we pay bills on behalf of the client?NoFilled from Services workbook.
  • Do we create invoices on behalf of the client?NoFilled from Services workbook.
  • Do we prepare a cash flow package?Not includedEntered on this record.
  • Do we prepare a budget for the client?Not includedEntered on this record.
  • Do we prepare custom reports?Not includedEntered on this record.
  • Do we provide business consulting?Not includedEntered on this record.
  • Do we maintain the asset register?Not includedEntered on this record.
  • Does the client claim vehicle expenses?Not includedEntered on this record.

Notes

Expense processing notes Record all inventory purchases to "11000 Inventor yAsset" and NOT "51000 Purchases of Inventory" starting September 2025 when you see deposits to bank account that just say "DEPOSIT" those are cash and cheque deposits. See the process in this loom video: https://www.loom.com/share/a6589c249a714de5969cf28184af572f?sid=b3524fc7-c9d1-4772-934f-c6e3b618c4dc Each month we must download the Consolidated Freightcom Invoices and upload to Booke for processing - https://scribehow.com/shared/How_to_Download_Invoices_from_Freightcom__dH5oG_aRR5KhFRza66QYFA How to match CAD Freightcom bills to USD payments https://scribehow.com/shared/How_to_Record_a_USD_payment_to_a_CAD_Bill__Currency_Conversion_in_QuickBooks__rd23NCPyTjqlmeCqZPXaCg Client pays previous owner amounts for utilities, land tax , etc. "Beutler Enterprises inc". Client will issue cheque, we will enter JE with details provided by email. Please use "05-2025 true up" JE example . The information is sent to the CM and normally entered by the CM The GWW bills are billed to us in USD, and then converted to CAD each day depending on the exchange rate. They charge the statement in CAD dollars. -THIS MAKES BILL PAYMENTS WEIRD BECASUE THEY PAY IN USD BUT BASED ON THE CANADIAN AMOUNT ON THE STATEMENT Prepaid accounts No Currency revaluation notes No

Tax & Deadlines

GST/HST

Registered

Quarterly - CalendarOct 31, 2026in 11 days

Banking

Bank accounts

20 accounts · 6 on QBO bank feed · 14 manual. Click an account for the full detail.

Gary
Bank—10040—Manual entry
Paypal CAD & 10080 Paypal USD -we have log in to fetch statements. Paypal USD should be inactive as of July
Bank•••• 202510070CADManual entry
TD CAD CHQ

QBO fetches look under Reconciled

Bank•••• 144410010CADQBO bank feed
TD USA

QBO Fetches - no active after Jan 2026

Bank•••• 0004——QBO bank feed
TD USA

QBO Fetches

Bank•••• 9841——QBO bank feed
Wise CAD & 10051 Wise USD https://www.loom.com/share/2f46daa5fb0548f5893732d6a6d63738?sid=09ef84ec-67c0-49a3-a9f2-80c680c7f3d2
Bank—10050CADManual entry
Aeroplan MC USD

QBO Fetches statement look under reconciled tab

Card•••• 177421040USDQBO bank feed
Amex CAD 21008 (previously 1006) (Client to Provide Statement) -INACTIVE AS OF SEP 2025 - NO MORE RECONCILIATIONS RECQUIRED FOR THE REST OF THE YEAR
Card—21020CADManual entry
Chase Ink 3471 (8159, 6163, 8144, 9753)

QBO Fetches

Card—21010—QBO bank feed
Chase Visa USD

QBO Fetches

Card•••• 778821012USDQBO bank feed
Citi MC USD 7810 (formerly 2413)

Client to provide statement

Card—21050USDManual entry
Amazon CAD Clearing
Clearing—12805CADManual entry
Amazon Reserve CAD
Clearing—12600CADManual entry
Amazon Sales Tax Collected
Clearing—22115—Manual entry
In Store POS Clearing

Shopify POS

Clearing—10100—Manual entry
Klarna Clearing

we have log in

Clearing—12865—Manual entry
Shopify CAD Clearing
Clearing—12860CADManual entry
Shopify Cash Clearing
Clearing—12870—Manual entry
Stripe CAD

have access PP tile

Clearing—10065CADManual · via tile
Stripe USD

Client to provide statement

Clearing—10066USDManual entry

Banking notes

No banking notes yet.

E-Commerce

Store #1Shopify Water eStore CA -the-Water-Filter-Estore
Store #2"Midland Store" - Shopify - CAD
Payment gatewaysPOS - Shopify Stripe Paypal
Monthly COGS entry %No
Document management appBooke.ai

E-Commerce Items

  • Does the client sell on Amazon?YesFilled from Platforms used.
  • Does the client use more than one currency?YesFilled from Client Details.
  • Do we provide the inventory package?NoEntered on this record.
  • Is all inventory tracked through Amazon only?NoEntered on this record.
  • Is all inventory tracked through Shopify only?NoEntered on this record.
  • Does the client send a monthly inventory value?NoEntered on this record.
  • Is COGS sent from A2X?NoEntered on this record.
  • Does the client give away Shopify gift cards?NoEntered on this record.
  • Does the client have e-comm sites withholding tax?NoEntered on this record.

E-commerce notes

Platforms used Shopify Amazon Integration apps Dext Commerce Inventory tracking method Client currently does not track inventory in QBO . CLIENT TO UPDATE GOOGLE SHEET FOR COGS MONTHLY. Https://docs.google.com/spreadsheets/d/1gwJlrVx_uPKukfsxro1QJPA2_hprhlZp6KGAUWe8bp8/edit?gid=227940660#gid=227940660 Monthly COGS adjustment method Purchases of inventory is posted to Inventory asset. Then on a monthly basis we will take the COGS values from Shopify and Amazon and record a journal entry. See loom: https://www.loom.com/share/f5c087e1cf394de5a4a9d5a51101c36f?sid=2fc471aa-9f32-43d8-9a43-ccdec0b5b476 E-commerce additional tasks No

Payroll

Payroll systemWagePoint - They Will Do Payroll Themselves Unless They Change Their Mind

Payroll Items

  • Does the client have payroll?YesFilled from Client Details.
  • Do we run payroll for the client?Not setFilled from Service package.
  • Do we email paystubs to employees?Not setEntered on this record.

Apps

6 apps·4 billed to XENA AI·0 without access

Marketplaces & sales channels

Dext Commerce

Dext Commerce

Marketplace

Access not recorded

Our access

Who paysNot recorded
RateNot recorded
LoginNot recorded
CategoryMarketplaces & sales channels

Receipts & documents

Booke.ai

Booke.ai

Receipts

Access not recorded

Our access

Who paysNot recorded
RateNot recorded
LoginNot recorded
CategoryReceipts & documents

Payments & gateways

Paypal

Payments

Access not recorded

Our access

Who paysXENA AI pays
RateNot recorded
LoginNot recorded
CategoryPayments & gateways

Stripe

Payments

Access not recorded

Our access

Who paysXENA AI pays
RateNot recorded
LoginNot recorded
CategoryPayments & gateways

Other apps

Wise

Other

Access not recorded

Our access

Who paysXENA AI pays
RateNot recorded
LoginNot recorded
CategoryOther apps

Klarna

Other

Access not recorded

Our access

Who paysXENA AI pays
RateNot recorded
LoginNot recorded
CategoryOther apps

Apps notes

No app notes yet.

Reports

0 linked reports·87 without a link·opens in QuickBooks

QBO custom reports

Links already on this client's workbook

SharePoint client folderClient file

No report links yet. Open a custom report in QuickBooks, copy the URL, and paste it against the report here.

Other details

Kind
ManualReport Name

Reports notes

No report notes yet.

Operating notes

How this client is handled — special rules, currency and payroll quirks, and the team's running memos.

Primary operating instructions

Processing rules, currency notes, cut-offs, owner preferences. Read this first.

Auto-saves to the workbook

Section rules & exceptions

Pulled from the workbook

1 of 4 sections have notes

E-commerce & stores

Shopify
Amazon

No notes yet:

Team memos

Nothing logged yet

Call outcomes, approvals, and handoffs land here — dated and attributed.

Coverage

1 of 5
  • Primary instructions
  • Payroll processing
  • Banking & feeds
  • E-commerce & stores
  • Tax compliance & filing

Section notes are edited at their source in the Workbook and mirrored here.