Loading daily joke...
๐Ÿ‘ˆ Select from the menu to get started
Use the sidebar to navigate between Purchase Invoices, Bank Reconciliation, Tasks, and more.

โŒ Royal Mail - Failed Shipments

Shipments that failed to create due to errors. View error details and link to manifest to retry.

Open Manifest โ†’

Loading...

Pending
-
Processed
-
Queried
-
Today
-
Date
Double-click to edit
Supplier
Double-click to edit
PDF Location Invoice # Type Assigned To Status
Loading invoices...
PDF Preview

Click an invoice to preview the PDF

๐Ÿ“ Purchase Invoice Date Amendment

Amend invoice dates by double-clicking the date field in the Purchase Invoices list.

โ„น๏ธ How to amend invoice dates:

  1. Go to Purchase Invoices from the menu
  2. Find the invoice you want to amend
  3. Double-click the date field in the invoice row
  4. Edit the date in the popup
  5. Changes are saved automatically

1. Upload Files

Invoice PDF from UPS Billing Portal
Large CSV export from UPS Billing Portal

๐Ÿ“‹ Instructions

How to Use This Portal:

  1. Download Files from UPS:
  2. Upload Files: Select both files above
  3. Process: Click "Process Invoice" button
  4. View Results: See PDF on the right, breakdown below
  5. Copy to Orderwise: Copy descriptions and amounts from the table
  6. Verify Total: Ensure Orderwise entry matches invoice total exactly

๐Ÿ“„ Invoice PDF

Upload a PDF file to view it here

๐Ÿงพ PO Invoice Entries

๐Ÿ“„ Invoice PDF

๐Ÿ“
Click to upload or drag & drop a PDF invoice

๐Ÿ“ฆ OrderWise Purchase Order

๐Ÿ“ฆ
Upload an invoice or search for a PO to get started

๐Ÿ›’ OnBuy Remittance Processing

Upload your OnBuy remittance CSV file to automatically match orders with Orderwise.

Instructions: Download the OnBuy remittance CSV from your OnBuy seller account, then upload it here. The system will match each OnBuy order to the corresponding Orderwise order.

๐Ÿ’ฐ Marketplace Fee Upload to Orderwise

Upload eBay CSV or Amazon XML files to automatically sync marketplace fees to OrderWise.

๐Ÿ“‹ How to Get the File from eBay:

  1. In eBay Selling Overview, click Reports within the Payments tab
  2. Log In to eBay if prompted
  3. Choose the time period according to the orders on OrderWise that need updated
  4. Click Download CSV and select "All"
  5. Upload the downloaded file using the form below

Note: The system will automatically sync Final Value Fees, Regulatory Operating Fees, and Promoted Listings fees to OrderWise. Priority fees are excluded (policy: cannot accurately allocate).

๐Ÿ”จ eBay Auctions โ€” Sell Similar

Load an existing listing, adjust price & duration, list instantly

๐Ÿ” Load Source Listing

โญ Saved Items

Loadingโ€ฆ

๐Ÿ”
Load a source listing
Enter an eBay Item ID on the left, or pick from Saved Items

๐Ÿ“‹ Listings Created

Title Price Condition SKU eBay Item Listed
Loadingโ€ฆ

๐Ÿ’ณ Amazon Refund Credits

Amazon refunds that may need credit notes created in OrderWise.

Pending
-
Processed
-
Total Amount (Pending)
ยฃ0.00
Order Reference Amount Customer Type Refund Date Reason Status Actions
Loading credits...
Total Spend (7d)
—
Total Sales VAT-adj (7d)
—
ROAS (7d)
—
ACoS (7d)
—

📁 Campaign Overview (7d SP)

Campaign ▽ Spend Sales ROAS ACoS Status Performance

๐Ÿฆ Amazon Bank Reconciliation

Upload Amazon payment files to auto-match and tick transactions in OrderWise bank reconciliation.

Upload Amazon Payment File

โ„น๏ธ The brh_id from OrderWise bank reconciliation
๐Ÿ“„ XML Settlement Report ๐Ÿ’ก Select multiple files (Spain, France, Germany, UK, etc.)
Automatically tick matched orders in OrderWise bank rec

๐Ÿ“œ Settlement History

Loading settlement history...

๐Ÿฆ AIB Bank Reconciliation

Paste your AIB bank transactions below to identify what needs receipting.

๐Ÿ“‹ Supplier Statements

๐Ÿ’ฐ Total Approved for Payment
ยฃ0.00
Supplier
Payment Method
Status
Amount
Statement Details

Select a statement to view details

โœ… Team Tasks

-
Total Tasks
-
High Priority
-
Due Today
โณ
Loading tasks...
Task Details

Select a task to view details

๐Ÿ“… Daily Tasks

๐Ÿ“Š Nominal Ledger History

๐Ÿ’ฌ eBay Messages

0 unread
๐Ÿ“ญ

Select a message

Choose a conversation from the list to view and reply

๐Ÿ“ฆ Container Finance Tracker

๐Ÿ“ฆ

No containers yet

Click "New Container" to get started

๐Ÿš— Number Plates

Total Plates
0
Number Plate Date Notes Actions
Loading...

๐Ÿ“Š OSS / Domestic VAT

โ„น๏ธ Note: This page has been moved to Tax Reports (opens in new tab).

๐Ÿ“Š Tax Reports

๐Ÿ‡ช๐Ÿ‡บ OSS VAT Report

How to use:

  1. Upload the VTR CSV file from Amazon
  2. Select the month/year to process
  3. Click "Run OSS Process"
  4. Reports will be saved to F: drive automatically
Upload the Amazon VTR file (CSV format)

๐Ÿ‡ช๐Ÿ‡บ Domestic VAT Report

How to use:

  1. Upload the Avask Excel file
  2. Select country, month, and year
  3. Click "Run Domestic VAT Process"
  4. Reports will be saved to F: drive automatically
Upload the Avask VAT report (Excel format)

๐Ÿ‡ฌ๐Ÿ‡งโžก๏ธ๐Ÿ‡ช๐Ÿ‡บ EC Sales Report

How to use:

  1. Upload the Amazon VTR CSV file
  2. Select the month/year to process
  3. Click "Upload VTR File"
Upload the Amazon VTR file (CSV format)

๐Ÿ“š OrderWise Support

Search documentation and guides

๐Ÿ›๏ธ Emergency VAT Return Submission

Use only if OrderWise MTD is unavailable

โš ๏ธ Important

  • This tool submits VAT returns directly to HMRC
  • Only use if OrderWise MTD integration is broken
  • Copy figures from OrderWise VAT report
  • Double-check all values before submitting
  • Submissions cannot be undone!

Currently in sandbox mode for testing. Production credentials pending HMRC approval.

VAT Return Details

Get this from 'Check Obligations' below

Box 1 + Box 2

Box 3 - Box 4 (can be negative)

๐Ÿ“Š UK VAT Return Summary Report

Generate the quarterly UK VAT summary report (combines sales, purchases, OSS data)

From VAT OSS Quarterly Records spreadsheet

From OrderWise VAT Return (Box 5)

๐Ÿ“ Required Files: Ensure you've exported Q[X] [YEAR] Sales.xlsx and Q[X] [YEAR] Purchases.xlsx to: F:\Accounts\Gary VAT Folders\UK VAT Returns\Q[X] [YEAR]\

Pending
-
Flagged
-
Approved
-
Rejected
-
Date Supplier Invoice # Tax Code Net (£) VAT (£) Gross (£) Status
Loading...
Select an invoice to preview

๐Ÿ“š OrderWise Knowledge Base

Loading articles...

๐Ÿ’พ VPS Backup to F: Drive

Backup VPS files to ces-app (100.114.77.49)

๐Ÿ“„ Last Backup

Loading...

๐Ÿ› ๏ธ Start New Backup

โš ๏ธ Note: Backup will run in the background. Check F:\VPS Backups\ for results.

๐Ÿ“‚ What gets backed up:

  • /root/clawd/ (all scripts and configs)
  • Databases (shipments.db, portal.db, knowledge_base.db)
  • Nginx configs
  • Systemd service files
  • Recent logs (last 7 days)