Skip to main content

How to use Magical Fees Audit Log

Magical Fees

Written by Stephen Smith
Updated over 2 weeks ago

Overview

The Audit Log tracks every fee applied across all of your orders, giving you a clear record of what was charged, when, and where. Whether you need to verify a specific fee, reconcile your revenue, or pull a report for your accountant, the Audit Log puts everything in one place.

Some orders have multiple fees applied to them. In those cases, the order will appear multiple times in the log -once for each individual fee -so you can see exactly what was charged.

Accessing the Audit Log

To open the Audit Log:

  1. Open the Magical Fees app from your Shopify admin.

  2. Click Audit Log in the top navigation menu.

You will see a table of all fees applied to orders within the selected date range, along with a summary bar at the top showing key metrics.

Understanding the Data

Summary Bar

At the top of the page, the summary bar gives you a quick snapshot of the data you are viewing:

  • Orders -The number of unique orders that had fees applied.

  • Fees applied -The total number of individual fees across all orders.

  • Total revenue -The combined revenue from all applied fees. If your store operates in multiple currencies, each currency total is shown separately.

Table Columns

The main table includes the following columns:

  • Date/Time -When the order was placed, shown in your store's timezone.

  • Order -The order name (e.g. #1042), which links directly to the order in your Shopify admin.

  • Fee Name -The name of the fee that was applied.

  • Fee Amount -The amount charged for this fee, displayed in the order's currency.

  • Location -The customer's state/province and country (e.g. "California, US").

  • Sales Channel -Where the order was placed, shown as a color-coded badge: Online Store (blue), POS (green), or Draft Orders (orange).

Using Filters

You can narrow down your audit log data using the filters above the table. Click the filter bar to expand the available options:

  • Search -Type to search across order names, fee names, and locations.

  • Date -Select a date range to control which orders are loaded. You can pick from preset ranges (Today, Yesterday, Last 7 days, Last 30 days, Last 60 days, Last 90 days, Last 365 days, Last week, Last month, Last quarter, Last year) or set a custom date range.

  • Fee Name -Filter to show only specific fees by name. You can select multiple fee names at once.

  • Location -Filter by customer location. You can select multiple locations.

  • Sales Channel -Filter by the sales channel where the order was placed (e.g. Online Store, POS, Draft Orders).

Note: By default, the audit log shows the last 60 days of order data. The date range controls which orders are fetched from Shopify. All other filters (search, fee name, location, sales channel) further narrow down the results after loading.

Saving and Managing Views

If you find yourself using the same set of filters regularly, you can save them as a view for quick access later.

Saving a View

  1. Set up your filters the way you want them (e.g. a specific fee name, date range, or sales channel).

  2. Click the Save as button that appears in the filter bar.

  3. Enter a name for the view (e.g. "Credit Card Fees" or "POS Orders Last 30 Days").

  4. Click Save.

Your saved view will appear as a new tab next to the All tab at the top of the page.

Managing Views

You can create up to 20 saved views. Each view tab has a menu with the following actions:

  • Rename -Change the name of the view.

  • Duplicate -Create a copy of the view with a new name, which is useful for building variations of the same filter set.

  • Edit -Open the filters panel to modify the view's filters. After making changes, click Save to update the view or Discard to revert.

  • Delete -Permanently remove the view.

To switch between views, simply click on the tab. The All tab always shows all applied fees with the default filters.

Exporting to CSV

You can export your audit log data as a CSV file for use in spreadsheets, accounting software, or your own records.

  1. Click the Export CSV button at the top-right of the page.

  2. If you have active filters, you will be asked to choose between:

    • Filtered applied fees -Only exports the fees matching your current filters.

    • All applied fees -Exports all fees within your date range, ignoring filters.

  3. Click Export CSV to download the file.

The exported CSV includes the following columns: Date/Time, Order ID, Order Name, Fee Name, Fee Amount, Currency, State/Province, Country, and Sales Channel. A summary section is included at the bottom of the file with totals for orders, fees applied, and revenue.

Unlocking Full Order History (Compliance Plan)

By default, the audit log has access to 60 days of fee order data. If you need to access your complete order history -for compliance, tax filings, or long-term record-keeping -you can upgrade to a Compliance plan.

Available Plans

  • Starter ($9/mo) -60 days of order history

  • Starter + Compliance ($19/mo) -Unlimited order history

  • Plus ($29/mo) -60 days of order history

  • Plus + Compliance ($79/mo) -Unlimited order history

How to Upgrade

  1. In the Audit Log, you will see a banner at the top that says "Access your full order history". Click View plans, or navigate to the plan page from the app settings.

  2. Select a Compliance plan (Starter + Compliance or Plus + Compliance).

  3. Confirm the plan change in Shopify.

Granting Order Access

After switching to a Compliance plan, you will need to approve an additional permission so the app can read your full order history. A banner will appear in the Audit Log asking you to grant the "read all orders" permission.

  1. Click Grant Access on the banner.

  2. Approve the updated access in the confirmation dialog.

Once granted, the Audit Log will show an "All time" date preset and your complete order history will be available. A Full History Access badge will appear next to the page title to confirm unlimited access is active.

Note: The "read all orders" permission is a Shopify-standard scope that allows the app to view orders older than 60 days. It does not give the app any ability to modify your orders.

Did this answer your question?