Data Export Service
  • 24 Jun 2025
  • 12 Minutes to read
  • Dark
    Light
  • PDF

Data Export Service

  • Dark
    Light
  • PDF

Article summary

Understanding the File Structure

The file is a single text document containing multiple, distinct sections. Each line belongs to a section, identified by its first character. Certain sections are summaries, while others provide corresponding detail, creating a hierarchical relationship.


Data Export File (SPOT_...TXT)

Primary Data Sections

[ V ]   [ C ]   [ I ]   [ S ]   [ N ]   [ R ]   [ X ]

            ↓         ↓

            [ D ]        [ Q ]

Detail Sections


  • Section Identifier: The first character of every line (V, C, I, etc.) tells you what kind of data the line contains.

  • Header Row: The first data line within each section is a header row, identified by |00| as its second field. This row defines the columns for all subsequent data lines in that section.

  • Delimiter: By default, fields are separated by a pipe (|). This can be configured to use commas instead.

V|00|Company|Store|VisitDate|DropoffVisits|DropoffPieces|DropoffOrders|PickupVisits|PickupPieces|PickupOrders|PromisedOrders|LateOrders
V|01|MyDryCleaner|0001|6/2/2025|2|3|3|1|3|3|15|0
C|00|Name|Company|Store|ID|Address1|Address2|City|State|Zip|Phone1|Phone2|Route|Stop|Status|SignupDate|FirstVisitDate|LastVisitDate|LastModifiedDate|EmailAddress|DisableMarketing|RewardsProgram|RewardsPoints|RewardsLevel|BirthDate|AccountNumber|ClientGUID|StoreGUID|BillingGroup|SignupOrigin|CCExpires|CCType|CCLast4|ReferralSource|ReferralDetail|SMSRouteReminders|CustomerType|APILastActivityDateTime|APILastActivityVersion|MarketingSource|FBStatus
C|01|Holme, Janet|MyDryCleaner|0001|DC7444||||||8807338764||||Enabled|6/2/2025 9:47:00 AM|||6/2/2025|poqenli@orpkhdgkakmjfinrvrfio.website|0||0|||DC7444|{1CCA4F09-FF0D-4B3D-AE79-E0A3AA96B025}|{E333AE59-E486-4A1A-90C6-FDD6F22EEB85}|Standard|CC||||||Null|Individual|6/2/2025 10:04:00 AM|APIv1|Taco Bell|
C|01|Reward, 3|MyDryCleaner|0001|DC7445|||Draper|UT|84020|8015555555||||Enabled|6/2/2025|6/2/2025|6/2/2025|6/2/2025||0|Reward3|4.65000000000001||||{8A125943-48C9-4344-88D3-02761D491DCC}|{E333AE59-E486-4A1A-90C6-FDD6F22EEB85}||S||||||Null|Individual|||Facebook|A
C|01|Jackson, Test|MyDryCleaner|0001|DC7446|1201 Richardson Dr||Richardson|TX|75080|2148642378||Hotel|18|Enabled|6/2/2025 3:24:59 PM|||6/2/2025|testjgrlsd@sdgfjil.com|0||0|||DC7446|{7E2110B1-D6E3-4898-B38E-EBF7FEBD6FBF}|{E333AE59-E486-4A1A-90C6-FDD6F22EEB85}|Standard|CC||||||True|Individual|6/2/2025 2:15:00 PM|APIv1||
I|00|Invoice|CustomerID|Company|Store|DepartmentGroup|CurrentStatus|Route|KioskPickup|ModifiedDate|PriceDelta|BasePriceDelta|UpchargeTotalDelta|AlterationTotalDelta|VoidTotalDelta|CouponTotalDelta|AdjustmentTotalDelta|DiscountTotalDelta|SubtotalDelta|EnviroTotalDelta|TaxTotalDelta|PieceCountDelta|WriteoffTotalDelta|Price|BasePrice|UpchargeTotal|AlterationTotal|VoidTotal|CouponTotal|AdjustmentTotal|DiscountTotal|Subtotal|EnviroTotal|TaxTotal|PieceCount|WriteoffTotal|DropoffDate|ReadyDate|PickupDate|VoidDate|WriteoffDate|PNPDate|PriceModifiedDate|PaidDate|PaidCash|PaidCheck|PaidCreditCard|PaidCashCredit|PaidAccount|PaidOther|TotalPaid|PiecesSold|OrdersSold|TaxPaid|EnviroPaid|CardType|DetailClerk|HotelName|DetailStore|AssembledStore|BagScan|SubscriptionCouponTotal|SubscriptionCouponTotalDelta|PickupClerk|LockerNumber|GlobalLockerNumber
I|01|06-000001|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 11:47:19 AM|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6/2/2025 11:47:00 AM||6/2/2025 11:48:00 AM||||||0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0|0.00|0.00||adm||0001||0|0.00|0.00|||
I|01|06-000001|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 11:47:48 AM|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0.00|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6/2/2025 11:47:00 AM||6/2/2025 11:48:00 AM|||||6/2/2025 11:47:48 AM|6.78|0.00|0.00|0.00|0.00|0.00|6.78|1|1|0.78|0.00||adm||0001||0|0.00|0.00|adm||
I|01|06-000002|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 11:48:31 AM|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6/2/2025 11:49:00 AM||6/2/2025 11:49:00 AM||||||0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0|0.00|0.00||adm||0001||0|0.00|0.00|||
I|01|06-000002|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 11:49:04 AM|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0.00|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6/2/2025 11:49:00 AM||6/2/2025 11:49:00 AM|||||6/2/2025 11:49:04 AM|6.78|0.00|0.00|0.00|0.00|0.00|6.78|1|1|0.78|0.00||adm||0001||0|0.00|0.00|adm||
I|01|06-000003|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 11:50:47 AM|5.65|6.00|0.00|0.00|0.00|-1.00|0.00|0.00|5.00|0.00|0.65|1|0.00|5.65|6.00|0.00|0.00|0.00|-1.00|0.00|0.00|5.00|0.00|0.65|1|0.00|6/2/2025 11:51:00 AM||6/2/2025 1:31:00 PM||||||0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0|0.00|0.00||adm||0001||0|0.00|0.00|||
I|01|06-000003|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 1:30:31 PM|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0.00|5.65|6.00|0.00|0.00|0.00|-1.00|0.00|0.00|5.00|0.00|0.65|1|0.00|6/2/2025 11:51:00 AM||6/2/2025 1:31:00 PM|||||6/2/2025 1:30:31 PM|5.65|0.00|0.00|0.00|0.00|0.00|5.65|1|1|0.65|0.00||adm||0001||0|0.00|0.00|adm||
D|00|Invoice|InvoiceDate|Company|Store|ModifiedDate|Item#|HSL|Department|Category|Item|Quantity|PieceCount|Price|Brands
D|01|06-000001|6/2/2025|MyDryCleaner|0001|6/2/2025 11:47:47 AM|001||DryCleaning|Pants|Regular|1|1|6.00|
D|01|06-000002|6/2/2025|MyDryCleaner|0001|6/2/2025 11:49:00 AM|001||DryCleaning|Pants|Regular|1|1|6.00|
D|01|06-000003|6/2/2025|MyDryCleaner|0001|6/2/2025 1:30:28 PM|001||DryCleaning|Pants|Regular|1|1|6.00|
S|00|Company|Store|CouponDate|CouponCode|Description|Count|TotalValue
S|01|MyDryCleaner|0001|6/2/2025||$1 Off (1)|1|-1.00
Q|00|Company|Store|Invoice|InvoiceDate|CouponDate|CouponCode|Description|Value|Clerk
Q|01|MyDryCleaner|0001|06-000003|6/2/2025|6/2/2025||$1 Off (1)|-1.00|adm
N|00|Company|Store|InventoryDate|BeginningBalance|IncomingTotal|OutgoingTotal|WriteoffPNPTotal|EndingBalance
N|01|MyDryCleaner|0001|6/2/2025|719,546.72|17.00|17.00|0.00|719,546.72
N|01|MyDryCleaner|0002|6/2/2025|250.27|0.00|0.00|0.00|250.27
N|01|MyDryCleaner|0003|6/2/2025|349.91|0.00|0.00|0.00|349.91
N|01|MyDryCleaner|0004|6/2/2025|21.69|0.00|0.00|0.00|21.69
N|01|MyDryCleaner|0005|6/2/2025|37.59|0.00|0.00|0.00|37.59
N|01|MyDryCleaner|0006|6/2/2025|129.10|0.00|0.00|0.00|129.10
R|00|Company|Store|ReportingDate|OutgoingAR|CashCredits|InvoiceCredits|ManualCredits|ARPayments|CCAdjustments|PayinsPayouts|PendingCCPayments|UncollectedFunds|Cash|Checks|AMEX|VisaMCDiscover|OtherCC
R|01|MyDryCleaner|0001|6/2/2025|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|19.21|0.00|0.00|0.00|0.00
X|00|Company|Store|ReportingDate|MTDGrossTotal
X|01|MyDryCleaner|0001|06/02/2025|18.00

Section Breakdown

The following is a breakdown of each section and its purpose.


V - Visit Totals

A high-level summary of daily customer visit activity.

Headers:

Company, Store, VisitDate, DropoffVisits, DropoffPieces, DropoffOrders, PickupVisits, PickupPieces, PickupOrders, PromisedOrders, LateOrders

Example:

V|01|My Dry Cleaner|0045|6/11/2025|140|235|115|59|360|163|170|0
  • DropoffVisits: 140

    There were 140 separate instances of customers coming in to drop off their items.

  • DropoffPieces: 235

    Across those 140 visits, a total of 235 individual garments or pieces were received.

  • DropoffOrders: 115

    The 235 pieces were grouped into 115 new orders. This indicates some customers dropped off items that were split into multiple orders during a single visit.

  • PickupVisits: 59

    There were 59 separate instances of customers coming in to pick up their finished orders.

  • PickupPieces: 360

    A total of 360 individual garments or pieces were picked up by customers.

  • PickupOrders: 163

    These 360 pieces fulfilled 163 completed orders that were picked up.

  • PromisedOrders: 170

    A total of 170 orders in the system had a promised-ready date of June 11, 2025.

  • LateOrders: 0

    Of the orders that were picked up on this day, 0 were completed after their original promised date.

C - Customer Records

Contains details for customers added/modified that day.

Additionally, as requested, a configuration change can modify the record to include any customer with invoice activity that day.

Headers:

Name, Company, Store, ID, Address1, Address2, City, State, Zip, Phone1, Phone2, Route, Stop, Status, SignupDate, FirstVisitDate, LastVisitDate, LastModifiedDate, EmailAddress, DisableMarketing, RewardsProgram, RewardsPoints, RewardsLevel, BirthDate, AccountNumber, ClientGUID, StoreGUID, BillingGroup, SignupOrigin, CCExpires, CCType, CCLast4, ReferralSource, ReferralDetail, SMSRouteReminders, CustomerType, APILastActivityDateTime, APILastActivityVersion

Example:

C|01|Customer, Test|My Dry Cleaner|0045|TA15288|||Sandy|UT|84070|4055321269||||Enabled|10/24/2023|10/24/2023|5/20/2025|5/20/2025||0|Inner Circle Rewards 5 OFF|1||||{2D4EEA9B-A94F-4625-B917-96C481185483}|{C1C6BB46-C8FA-4D37-9A21-69608CFB4ED2}||S|03-30|VISA|7664|Drive By||False|Individual|6/10/2025 4:36:26 PM|APIv2

This line is for customer 'Customer, Test' (Customer ID: TA15288).

  • Name: Customer, Test

  • Company: My Dry Cleaner

  • Store: 0045

  • ID: TA15288 (The customer's unique identifier in the system)

  • Address1 & Address2: Blank

  • City: Sandy

  • State: UT

  • Zip: 84070

  • Status: Enabled (The account is active).

  • SignupDate: 10/24/2023 (The date the customer originally signed up).

  • FirstVisitDate: 10/24/2023 (The date of the customer's first transaction).

  • LastVisitDate: 5/20/2025 (The date of their most recent transaction).

  • LastModifiedDate: 5/20/2025 (The last date this customer's record was changed in any way).

  • Phone1: 4055321269

  • EmailAddress: Blank

  • DisableMarketing: 0 (This is a boolean 'False', meaning the customer can receive marketing).

  • SMSRouteReminders: False (The customer has opted out of receiving SMS reminders for their route).

  • RewardsProgram: Inner Circle Rewards 5 OFF (The name of the rewards program they are enrolled in).

  • RewardsPoints: 1 (The customer's current points balance).

  • ReferralSource: Drive By (How the customer heard about the business).

  • CCExpires: 03-30 (The credit card on file expires in March of 2030).

  • CCType: VISA

  • CCLast4: 5858 (The last four digits of the credit card).

  • CustomerType: Individual (As opposed to a 'Business' account).

  • SignupOrigin: S (A system code indicating the signup source, "Store").

  • ClientGUID & StoreGUID: {2D4EEA9...} and {C1C6BB...} (These are unique system-generated identifiers used for internal database tracking and API calls).

  • APILastActivityDateTime: 6/10/2025 4:36:26 PM (The last time this customer's data was accessed or updated via the API).

  • APILastActivityVersion: APIv2 (The version of the API used for the last activity).

I - Invoice Summary & D - Invoice Detail

These two sections work together. I shows events happening to an invoice (like creation and payment), while D shows the items on that invoice.

Invoice Summary Headers:

Invoice, CustomerID, Company, Store, DepartmentGroup, CurrentStatus, Route, KioskPickup, ModifiedDate, PriceDelta, BasePriceDelta, UpchargeTotalDelta, AlterationTotalDelta, VoidTotalDelta, CouponTotalDelta, AdjustmentTotalDelta, DiscountTotalDelta, SubtotalDelta, EnviroTotalDelta, TaxTotalDelta, PieceCountDelta, WriteoffTotalDelta, Price, BasePrice, UpchargeTotal, AlterationTotal, VoidTotal, CouponTotal, AdjustmentTotal, DiscountTotal, Subtotal, EnviroTotal, TaxTotal, PieceCount, WriteoffTotal, DropoffDate, ReadyDate, PickupDate, VoidDate, WriteoffDate, PNPDate, PriceModifiedDate, PaidDate, PaidCash, PaidCheck, PaidCreditCard, PaidCashCredit, PaidAccount, PaidOther, TotalPaid, PiecesSold, OrdersSold, TaxPaid, EnviroPaid, CardType, DetailClerk, HotelName, DetailStore, AssembledStore, BagScan, SubscriptionCouponTotal, SubscriptionCouponTotalDelta, PickupClerk, LockerNumber, GlobalLockerNumber

Example for invoice 04-450318:

I|01|04-450318|UM1250|My Dry Cleaner|0045|Laundry|Sold|Not Specified|0|6/11/2025 10:22:19 AM|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0.00|3.19|3.19|0.00|0.00|0.00|0.00|0.00|0.00|3.19|0.00|0.00|1|0.00|4/2/2025 1:05:00 PM|4/3/2025 11:00:00 AM|6/11/2025 10:22:00 AM||||||0.00|0.00|0.00|0.00|0.00|0.00|0.00|1|1|0.00|0.00||FH ||0045|0045|0|0.00|0.00|TVT||

This line records an event for Invoice 04-450318 belonging to Customer UM1250. We’ll cover the important headers below.

  • Invoice: 04-450318 (The unique invoice number)

  • CustomerID: UM1250 (Links to the customer in the 'C' section)

  • Store: 0045

  • DepartmentGroup: Laundry

  • CurrentStatus: Sold (The status of the invoice after this event)

  • ModifiedDate: 6/11/2025 10:22:19 AM (The exact timestamp of this event)

These fields show what changed in this specific event.

  • PriceDelta, SubtotalDelta, PieceCountDelta: All are 0.00 or 0.

  • What this means: Since the delta (change) values are zero, this line does not represent a new charge or payment. Instead, it is recording a status change. In this case, the invoice was marked as picked up, which changed its status to Sold.

These fields show the total values for the invoice at the time of this event.

  • Price & Subtotal: 3.19 (The total cost of the invoice is $3.19).

  • CouponTotal, AdjustmentTotal, DiscountTotal: All are 0.00, indicating no discounts were applied.

  • PieceCount: 1 (The invoice contains one item).

  • DropoffDate: 4/2/2025 1:05:00 PM (When the item was originally dropped off).

  • ReadyDate: 4/3/2025 11:00:00 AM (When the item was promised to be ready).

  • PickupDate: 6/11/2025 10:22:00 AM (The date the customer picked up the item, which is the primary action triggering this event record).

  • TotalPaid: 0.00

    Note: Even though the invoice is Sold, this specific line shows a TotalPaid of zero. This means the payment event was recorded on a different line, likely on a previous day. This line's purpose is only to record the pickup.

  • PiecesSold: 1

  • OrdersSold: 1

    This pickup event resulted in the "sale" of 1 piece and 1 order.

  • DetailClerk: FH (Initials of the employee who created the invoice).

  • PickupClerk: TVT (Initials of the employee who handled the pickup).

  • DetailStore & AssembledStore: 0045 (The store where the item was processed).

  • KioskPickup: 0 (Boolean 'False', meaning this was not picked up from a kiosk).

  • LockerNumber / GlobalLockerNumber: Blank, so this was not a locker transaction.


Invoice Detail Headers:

Invoice, InvoiceDate, Company, Store, ModifiedDate, Item#, HSL, Department, Category, Item, Quantity, PieceCount, Price, Brands

Example for invoice 04-450318:

D|01|04-450318|4/2/2025|My Dry Cleaner|0045|6/11/2025 10:22:19 AM|001|AAW1517021|Laundry|Shirt|On Hanger|1|1|3.19|Bugatchi

This line describes the single item on Invoice 04-450318.

  • Invoice: 04-450318

    This is the invoice number that this line item belongs to. It directly links this detail record to the corresponding I section record.

  • InvoiceDate: 4/2/2025

    The original creation date of the invoice. Note that this is different from the ModifiedDate, which reflects a more recent event.

  • Company & Store: My Dry Cleaner, 0045

    Standard identifiers for the business and the specific store location.

  • ModifiedDate: 6/11/2025 10:22:19 AM

    The timestamp of the last event that affected this line item. In this case, it matches the pickup event time from the I record, indicating the item was finalized for pickup at this moment.

  • Item#: 001

    This is the first item (line 1) on the invoice.

  • HSL: AAW1517021

    This is the Heat Seal Label number. It is a unique barcode or tracking ID physically attached to the garment for production and tracking purposes.

  • Department: Laundry

    The primary Department for this item (e.g., Laundry, Dryclean, Household).

  • Category: Shirt

    The general type of garment.

  • Item: On Hanger

    The specific service or description for this garment.

  • Quantity: 1

    The number of items being charged on this specific line.

  • PieceCount: 1

    The total number of physical pieces this line represents. For a single shirt, this is 1. For a "2-Piece Suit," the Quantity would be 1 but the PieceCount would be 2.

  • Price: 3.19

    The price for this single line item is $3.19. This is the base price before any invoice-level discounts or taxes are applied.

  • Brands: Bugatchi

    The brand of the garment.

S - Specials (Coupons) & Q - Coupon Detail

This section provides a daily summary of every coupon code used across all transactions in a given store. It aggregates the total usage and value for each distinct coupon.

S Headers:

Company, Store, CouponDate, CouponCode, Description, Count, TotalValue

Q Headers:

Company, Store, Invoice, InvoiceDate, CouponDate, CouponCode, Description, Value, Clerk
// SUMMARY: A coupon was used today
S|01|My Dry Cleaner|0099|6/11/2025|EM2T3NV20|EM2T3NV20|1|-9.40

// DETAIL: It was used on this specific invoice
Q|01|My Dry Cleaner|0099|05-992421|5/28/2025|6/11/2025|EM2T3NV20|EM2T3NV20|-9.40|NC

The S record line summarizes the usage of a specific coupon code at Store 0099 for the entire day of June 11, 2025.

  • Company & Store: My Dry Cleaner, 0099

    Standard identifiers for the business and the specific store where the coupon was used.

  • CouponDate: 6/11/2025

    The date on which the coupon(s) were applied.

  • CouponCode: EM2T3NV20

    The unique internal code for this specific coupon or promotion.

  • Description: EM2T3NV20

    A text description of the coupon. In this case, it's the same as the code, but it could also be a more descriptive name like "20% Off All Dry Cleaning".

  • Count: 1

    This specific coupon code (EM2T3NV20) was used a total of 1 time today at this store.

  • TotalValue: -9.40

    The total aggregated value of all applications of this coupon for the day. Since the count is 1, the total value is -$9.40. If it had been used twice with the same value, this field would show -18.80.

The Q line shows exactly where and when the coupon from the S section was used.

  • Company & Store: My Dry Cleaner, 0099

    Standard business and store identifiers.

  • Invoice: 05-992421

    The specific invoice number on which the coupon was applied. This is the primary link back to the I (Invoice) section.

  • InvoiceDate: 5/28/2025

    The original creation date of the invoice. Notice this is different from the CouponDate, meaning the coupon was applied to a pre-existing invoice.

  • CouponDate: 6/11/2025

    The date the coupon was actually applied to the invoice, matching the date in the S record.

  • CouponCode & Description: EM2T3NV20, EM2T3NV20

    The code and description of the coupon, linking this detail line back to its summary line in the S section.

  • Value: -9.40

    The actual discount amount for this single application of the coupon was -$9.40.

  • Clerk: NC

    The initials of the employee or clerk who applied the coupon to the invoice.

The S section tells us that on June 11th, the coupon EM2T3NV20 was used a total of 1 time for a total discount of $9.40.

The Q section provides the specific detail for that one use: it was applied to invoice 05-992421 (which was created on May 28th) by clerk NC.

L - Labor / Timeclock

This section provides a summary of employee hours worked on the reporting date. The data is broken down by store and the employee's job category, making it useful for tracking labor costs, productivity, and staffing levels.

Headers:

Company, Store, ClockinDate, Category, EmployeeID, EmployeeName, Hours

Example:

L|01|My Dry Cleaner|0045|6/11/2025|Assembler|0|Test, Davidson|6.15

This line represents a timeclock summary for a single employee in a specific role for the day.

  • Company: My Dry Cleaner

    The name of the company.

  • Store: 0045

    The unique identifier for the store where the hours were worked.

  • ClockinDate: 6/11/2025

    The date for which these labor hours are being reported.

  • Category: Assembler

    The Production Category under which the employee worked these hours.

  • EmployeeID: 0

    The internal system ID for the employee.

  • EmployeeName: Test, Davidson

    The name of the employee who worked the hours.

  • Hours: 6.15

    The total number of hours worked by this employee in this category for the specified date, expressed as a decimal. In this case, 6.15 hours is equivalent to 6 hours and 9 minutes (0.15 * 60 minutes).

N - Inventory

This section is a financial reconciliation of inventory value for the day.

Headers:

Company, Store, InventoryDate, BeginningBalance, IncomingTotal, OutgoingTotal, WriteoffPNPTotal, EndingBalance

Example:

N|01|MyDryCleaner|0001|6/2/2025|719,546.72|17.00|17.00|0.00|719,546.72

For store 01 on 6/2/2025, the BeginningBalance was $719,546.72 with an IncomingTotal of $17.00 that was added today, and an OutgoingTotal of 17.00 was removed (picked up by customers). The EndingBalance remained the same at $719,546.72

R - Register/Cash Drawer

This section is a summary of the day's financial activity by tender type.

Headers:

Company, Store, ReportingDate, OutgoingAR, CashCredits, InvoiceCredits, ManualCredits, ARPayments, CCAdjustments, PayinsPayouts, PendingCCPayments, UncollectedFunds, Cash, Checks, AMEX, VisaMCDiscover, OtherCC

Example:

R|01|My Dry Cleaner|0045|6/11/2025|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|139.64|0.00|197.37|1,707.03|0.00

This line summarizes the register activity for Store 0045 on June 11, 2025.

  • OutgoingAR: 0.00

    $0.00 in new charges were posted to Accounts Receivable.

  • CashCredits: 0.00

    $0.00 in cash credits were issued.

  • InvoiceCredits: 0.00

    $0.00 in general invoice credits were issued.

  • ManualCredits: 0.00

    $0.00 in credits were issued manually by staff.

  • ARPayments: 0.00

    $0.00 was received as payments on existing AR balances.

  • CCAdjustments: 0.00

    $0.00 in credit card adjustments were made (e.g., for refunds or corrections).

  • PayinsPayouts: 0.00

    The net total of cash paid into or taken out of the drawer for non-sales reasons was $0.00.

  • PendingCCPayments: 0.00

    $0.00 in credit card payments are still pending settlement.

  • UncollectedFunds: 0.00

    $0.00 in funds from previous transactions remain uncollected

  • Cash: 139.64

    A total of $139.64 was tendered as cash.

  • Checks: 0.00

    $0.00 was tendered in checks.

  • AMEX: 197.37

    A total of $197.37 was tendered via American Express cards.

  • VisaMCDiscover: 1,707.03

    A total of $1,707.03 was tendered via Visa, MasterCard, or Discover cards.

  • OtherCC: 0.00

    $0.00 was tendered via other, less common credit card types.

X - Month-to-Date (MTD) Totals

A simple, informational snapshot of gross sales for the month so far.

Headers:

Company, Store, ReportingDate, MTDGrossTotal
X|01|My Dry Cleaner|0045|06/11/2025|24073.44

As of the end of the day on June 11, 2025, the MTD gross sales total for store 0045 is $24073.44

The X Section

The X section total is a highly reliable estimate but is not guaranteed to be 100% auditable against the sum of all daily invoice (I) records. It is intended for at-a-glance operational awareness, not for precise financial reconciliation.

B - Locker Information

This optional section provides a detailed inventory of every locker configured for a given store group. It is designed to serve as a master reference list of physical locker locations and their system identifiers. It is not enabled by default and is only enabled by request.

Headers:

Company, StoreGroup, LockerBank, Description, GlobalLockerNumber, LocalLockerNumber, LockerNumber

Example:

B|01|MyDryCleaner|1001 Ross|Lockers located in the package area.|LK12287|2287

This line describes a single locker door within a specific locker bank.

  • StoreGroup: My Dry Cleaner

    The store to which the Locker Bank and locker doors belong to.

  • LockerBank: 1001 Ross

    The name of the Locker Bank, as configured in Connect’s delivery section.

  • Description: Lockers located in the package area.

    A free-text description providing specific instructions or notes on where to find this locker bank. This helps operational staff and delivery drivers locate the lockers efficiently.

  • GlobalLockerNumber: LK12287

    The system-wide unique identifier for a single locker door. This ID is unique across all stores and locations within the entire SPOT system. The 'LK' prefix is a standard part of this identifier.

  • LocalLockerNumber: 2287

    The number that is physically displayed on the locker door itself. This is the number a customer or delivery driver would see and use on-site. It is typically unique only within its specific LockerBank.


Was this article helpful?