How to Create an Accounts Receivable Dashboard in Google Analytics

While Google Analytics is a powerhouse for tracking website performance, it isn’t accounting software and doesn't directly track your accounts receivable. However, you can use it to build an incredibly valuable e-commerce revenue dashboard that shows you where your future revenue and receivables are coming from. This tutorial will show you exactly how to set up this dashboard and how to pair that data with your accounting system for a complete financial picture.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First, Let's Set the Right Expectations: GA vs. Accounting Software

Before building anything, it's important to understand what Google Analytics is designed for and where its financial tracking capabilities end. Think of it as the "top of the financial funnel" tracker.

What Google Analytics Tracks Excellently:

• E-commerce Transactions: Which products were sold, the quantity, and the revenue associated with that sale at the time of purchase.
• Sources of Revenue: Which marketing channels (Organic Search, Paid Ads, Social Media, Email) drove the transactions.
• Goal Completions: For non-e-commerce sites, you can assign a monetary value to a goal, like a submitted lead form, to estimate potential revenue.
• User Path to Purchase: The pages a user visited before they made a purchase, giving you insight into your customer journey.

What Google Analytics Does Not Track:

• Invoice Status: It doesn't know if an invoice has been sent, paid, or is overdue.
• Payment Methods & Fees: It won't see data from Stripe or PayPal about processing fees or chargebacks.
• Refunds (Accurately): While there are ways to send refund data to GA, it's often complex and doesn't always reflect the full picture visible in your e-commerce backend (like Shopify or WooCommerce).
• Accounts Receivable Aging: GA has no concept of tracking how long an invoice has been outstanding.

In short, Google Analytics shows you the value of transactions generated on your website. Your accounting software (like QuickBooks, Xero, or FreshBooks) shows you the actual cash flow and manages receivables. Our goal here is to build a dashboard in GA that focuses on what it does best: connecting marketing efforts to generated revenue.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Pre-Requisites: Enable E-commerce Tracking

To see any financial data in Google Analytics, you must have E-commerce tracking set up correctly. This process sends transaction and item data from your online store to Google Analytics. If you haven't done this yet, it's your first step.

Most modern e-commerce platforms have straightforward integrations for this:

• Shopify: You can enable Google Analytics 4 tracking natively within your Shopify admin under Online Store > Preferences.
• WooCommerce: There are several popular plugins, like "Google Analytics for WordPress" by MonsterInsights or "GA Google Analytics," that make this setup simple.
• Other Platforms: Look through your platform's app store or documentation for a "Google Analytics 4" integration. The setup usually involves simply adding your GA4 Measurement ID ("G-XXXXXXXX").

Once enabled, data will start flowing into GA4 as purchases happen on your site, populating the reports with transaction values, items sold, and more.

Building Your Revenue Performance Dashboard in GA4

Vanilla GA4 reports are useful, but for a true dashboard feel, we’ll use the "Explore" section to build a custom report. This allows us to combine different visualizations into a single view.

From your GA4 property, navigate to Explore on the left-hand menu and create a new Blank exploration.

1. Importing Your Metrics and Dimensions

In the "Variables" column on the left, you’ll see sections for Dimensions and Metrics. Think of Dimensions as what you want to measure (e.g., 'Channel,' 'Product Name') and Metrics as the numbers you want to count (e.g., 'Revenue,' 'Transactions').

Click the "+" icon next to Dimensions and add the following:

• Session default channel group
• Item name
• Transaction ID
• Date

Click the "+" icon next to Metrics and add these:

• Average purchase revenue
• Ecommerce quantity
• Purchase revenue
• Transactions
• Session conversion rate

Go ahead and "Apply" them. Now they're ready to use in our dashboard widgets.

2. Widget 1: Key Performance Indicators (KPIs)

First, let’s get a high-level overview of our performance. We'll use "Scorecard" visualizations for this.

• In the main "Tab Settings" column, change the Visualization from "Table" to "Scorecard."
• Drag the Purchase revenue metric from the Variables list into the "Values" box under Tab Settings. You now have a big number showing your total revenue.
• Right-click on this scorecard in the report canvas and choose "Duplicate." Repeat this process to create additional scorecards for a few more key metrics:

You can drag these scorecards around to arrange them neatly at the top of your dashboard. This gives you an immediate pulse-check on financial performance.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

3. Widget 2: Revenue By Marketing Channel

Next to the KPI cards, click the "+" icon to add a new widget. Let's find out which channels are driving the most revenue.

• For this tab, choose the Donut chart visualization style.
• Drag Session default channel group to the "Slices" field.
• Drag Purchase revenue to the "Values" field.

Instantly, you have a beautiful chart breaking down your revenue by source - Organic Search, Direct, Email, Paid Social, etc. You can now clearly identify the marketing activities filling up your potential accounts receivable pipeline.

4. Widget 3: Top Performing Products

Let's add another widget to see what people are buying. Click the "+" icon to add a new tab again, but this time, keep it as a default Table.

• Drag Item name to the "Rows" field.
• Drag Ecommerce quantity and Purchase revenue into the "Values" field.
• By default, it will sort by the first metric. Click the header of the "Purchase revenue" column in the table to sort by your top-grossing products.

This widget tells you which products are your cash cows, which can inform your inventory, advertising, and content strategy.

5. Widget 4: Revenue and Transactions Over Time

Finally, let's create a trendline. Add one more widget by pressing the "+," this time choosing a Line chart.

• Drag your Date dimension to the "X-axis".
• Drag Purchase revenue and Transactions metrics to the "Y-axis".

This visualization helps you spot trends, understand seasonality, and see the immediate impact of major marketing campaigns or site changes on your revenue and order volume.

Give your exploration a helpful name like "Revenue & E-commerce Dashboard" and it will autosave. Now you have a clean, one-page report tracking the health of your online revenue generation.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Bridging the Gap: Connecting GA Data to Your Actual AR

Now that you have a dashboard showing how revenue is generated, the final step is to reconcile this with the data in your accounting system. The GA dashboard identifies trends and opportunities, your accounting system verifies the cash flow.

The Manual Method: Using Google Sheets or Excel

The simplest way to connect these two data worlds is with a spreadsheet. It takes a little manual effort but provides a powerful link between marketing and finance.

1. Export from Google Analytics: In your new GA4 dashboard, you can export the data from each widget to Google Sheets or a CSV. You'll want to export a table containing at least Transaction ID and Purchase revenue.
2. Export from Accounting Software: Go into QuickBooks, Xero, Stripe, or whatever you use for invoicing and export a report of paid invoices for the same time period. Make sure this report includes the invoice number or transaction ID and the amount paid.
3. Combine and Reconcile: In Google Sheets or Excel, bring both sets of data in. Using a VLOOKUP or INDEX(MATCH) function, you can match the Transaction ID from Google Analytics to the corresponding invoice in your accounting data. This helps you confirm whether the revenue GA reported was actually collected. It also highlights any discrepancies, like refunds or failed payments, that GA might not have seen.

By comparing the totals, you can calculate a true "collection rate" by marketing channel - which is far more valuable than simply looking at revenue alone.

Final Thoughts

While you can't technically create an Accounts Receivable report directly within Google Analytics, you can - and should - build a powerful revenue performance dashboard. This gives your marketing and sales teams a direct view into what channels and products are generating transactions that will (hopefully) become paid invoices.

To really streamline this, connecting your data sources automatically is the way to go. Here at Graphed, we built our tool to eliminate the manual spreadsheet work completely. We easily connect to Google Analytics, Shopify, QuickBooks, and Salesforce, putting all of your marketing, sales, and financial data in one place. You can then use simple, natural language to ask questions like, "Which marketing channels from Google Analytics have the best revenue collection rate based on QuickBooks data?" creating real-time, cross-platform reports that tell the whole story, from first click to cash in the bank, using Graphed dashboards.