Analytics Payments
The Analytics Payments table can be extremely helpful to summarize and filter information for your payments. In its default setting, the table actually breaks up each payment by line item. This allows you to see specific information about the component parts of that payment, such as ad size, sales rep, or service name. You can always choose to sort or filter this information to get a personalized report. For instance, you could group by company or filter by invoice due dates that have passed. There is also a URL link in the table, which can take you to the corresponding company’s payments page in the system.
Breakdown of Data
Brand Name
Company Name
Publication Name
Publisher
Ad Size
Service Name
Barter Payments - The amount paid that is in a form of payment other than actual cash, such as a gift card.
Invoice Date – This is often the date that the invoice was created, but may be different depending on the specific invoice. For example, the invoice date that is part of an installment may be a month or two away.
Invoice Due Date - Shows when the invoice is due.
Invoice ID - Every invoice in the system gets a unique identification number. We recommend using the ID if you ever want to import data to an invoice or join a table to get more information about an invoice. Using IDs is a better way to join than by name.
Line Item Key - Every line item in the system gets a unique identification number, which is created when you add an order. The line item key is a good way to join two tables together or if you want to import data to a line item.
Payment Date – The date the payment was recorded in the system.
Payments – The amount of the recorded payment on the specific line item.
Payments URL - The URL link will take you to the chosen Company’s Payments tab.
PO Number – Every purchase order that is created in the system has a unique identification number. We recommend using the PO number if you want to import data or join a table to get more information about a purchase order.
Sales Rep - The rep for the line item.
Tender – The form that the payment was made in, such as cash, check, etc.