Account Reports

 

Back Office >Reports > Accounts

 

Description

 

Nearly all of the Reports in SwiftPOS can be filtered by either a date range or data. The date range can either be selected from the drop down list of Periods or entered manually.

 

Note : Account Classifications that have been assigned to individual Location Groups (Venues) will use the Location Group (Venue) Contact Info for Statements.

 


Reports

 

Report Name

ID

 Sample

Description

Abbreviated Account Listing

ACC001

R

Reports on Accounts. Lists Account #, Account Name, Address, Account Balance, Limit, Phone #, Class and Active From/To dates information. This report can also be sorted by Post Code, Last Name or Account #.

Account Activity Consolidated

ACC024

R

Reports on Accounts. Lists Account #, Account Name, Credit Limit, Payment Txns (number of Payment transactions), Payment Total, Charge Txns (number of Charge transactions), Charges Total and Total. This report can also be sorted by Account # or Account Name.

Account Activity Detail

ACC003

R

Reports on Account related transactions. Lists Location/Venue, Terminal, Receipt #, Data/Time, Clerk, Account Type and transaction Amount information. It also lists the PLU, Product Description, Qty, Item Price and Sales Price for all items sold.

Account Activity Summary

ACC002

R

Reports on Account related transactions. Lists Location/Venue, Terminal, Receipt #, Data/Time, Clerk, Account #, Account Name, Payment amount and Charge/Credit amounts information.

Account Receipts Audit

ACC006

D S

Reports on Account Receipts. Lists Account #, Account Name, Receipt #, Date, Reference, Media Type, Amount Paid, Amount Allocated information.

 

In addition the detailed version lists the Receipts per Reference.

Account Tax Statement

ACC023

R

Reports on Account Charge/Payment transactions for the period selected, in an Account Statement format. Lists the Account and Address details, Location, Date/Time of the transaction, Receipt #, Type, Product, Qty, Tax, Price, Transaction Amount and Charged/Payment Amount. Statements can be generated by selecting one of the following Type options available.

Account Transaction Listing

ACC009

R

Reports on Account related transactions grouped by Account. Reports each Account on a new page. Lists Account Name, Address, Transaction Date, Location, Receipt #, Cost Total, Sale Total, Tax Total, Charge Total, Payment Total, Account Balance.

Account Transaction Listing 2

ACC019

R

Reports on Account related transactions grouped by Account. Reports each Account on a new page. Lists Account, Transaction Date/Time, Receipt, Location, Docket Type, PLU/Product Code, Description, Qty, Amount, Charge/Payment Amounts and Current Balance

Account Transaction Summary

ACC010

R

Reports on Account related transactions grouped by Account and Location. Lists Account #, Account Name, Terminal, Receipt #, Date/Time, Clerk, Total Cost, Sales (Ex.), Sales (Inc.), Charged and Paid information.

Aged Balances

ACC004

R

Reports on Accounts in debt grouped by Classification. Amounts owed are reported in periods based on the setting set here and the date of the transaction. Lists Account, Contact #, Credit Limit, Account Balance, Amount Due, Current, 30 Days, 60 Days, 90+ Days, Charges, Payments, dates of Last Sale and Last Payment. This report can be sorted by Member Name, Member # or Member Balance.

Aged Balances by Location Group

ACC022

R

Reports on Accounts in debt grouped by Classification. Amounts owed are reported in periods based on the setting set here and the date of the transaction. Lists ID, Name, Phone, Credit Limit, Balance, Current, 30 Days, 60 Days, 90+ Days, Credits, Payments, dates of Last Sale and Last Payment. This report can be sorted by Member Name, Member # or Member Balance.

Aged Balances by Sub Account

ACC005

R

Reports on Accounts in debt that are linked to other Accounts. Amounts owed are reported in periods based on the setting set here and the date of the transaction. Lists Account #, Name, Phone #, Credit Limit, Account Balance, Amount Due, Current, 30 Days, 60 Days, 90+ Days, Credits, Payments, dates of Last Sale and Last Payment. This report can be sorted by Member Name, Member # or Member Balance.

 

The aged balances by sub account report is the same as the Aged Balances report, except it will also report on any Linked Members linked to the original Member.  By default, the linked Members info will be reported with the original Member returned via the report filtering.  All linked Members are shown for the original Member in the report regardless of filtering.  In addition the detailed version lists the linked Members information separated onto their own individual lines.

Classification Summary Report

ACC007

R

Reports on Accounts grouped by Location and/or Classification. Lists Account, Balance, Charges, Payments and the date of the Last Transaction.  This report can be sorted by Account # or Name.

Debtors Statement

ACC013

R

Similar to the Tax Invoice (Statement) report, only it reports on remittance details down the right hand side. It also allows Customers/Members to select the invoices to which their payment should be allocated to. Statements can be generated by selecting one of the following Type options available.

ePurse Aged Balances

ACC014

R

Similar to the Aged Balances (ACC022) report, except it reports on ePurse Accounts.

Statement of Account

ACC020

R

Reports on all the Customer/Member Account transactions for the period selected. Lists the Account # and Name, the opening Balance, Receipt # and Date/Time, Amounts for Payments/Refunds and Charges, as well as a running Balance and Closing Balance.

Tax Invoice [Statement]

ACC015

R

Reports on all the Customer/Member's Account transactions for the period they have been a Customer/Member. Additional data is available on the bottom of this report to give a summary of purchases for a Family of Products. This is also used for sites that sell Fuel. Statements can be generated by selecting one of the following Type options available.

If you have been selling Text/String Products, then the text that was entered will display after the POS Display description for the Text/String Product. An example of this would show Room: 12345 as the description if you want to reference something in the sale.

 

Tax Invoice Detail/Summary

ACC016

D S

D S

D S

D S

Reports on Customer/Member Account transactions grouped either by Master Group, Product Group, Receipt or Product Code/PLU. Lists The Customer/Member Name, Address and Account No., Reference, Master Group / Product Group / Terminal/Receipt / Product Code/PLU.

 

In addition the detailed version lists the Terminal/Receipt, Product Code/PLU and Description, Average Unit Price, Quantity and Extended Price.

Top-Bottom Accounts By Location Report

ACC018

R

Reports on the top/bottom number of Accounts based on total sales grouped by Location. Lists Location #, Location Name, Account #, Account Name, total Charged, Account Balance, total Cost, total Sales Ex, total Profit, Gross Profit % and date of Last Transaction information. This report can be sorted by Sales Value or Profit.

Top/Bottom Accounts Report

ACC017

R

Reports on the top/bottom number of Accounts based on total sales. Lists Account #, Account Name, total Charged, Account Balance, total Cost, total Sales Ex, total Profit, Gross Profit % and date of Last Transaction information. This report can be sorted by Sales Value or Profit.

 


Other Reports

 

SwiftPOS Back Office > Accounts > Account Payments

 

Report Name

ID

 Sample

Description

Account Adjustment

SPAY001

R

An Account Adjustment statement based on a Payment made via the Accounts > Process Payments screen in Back Office.

Account Payment

SPAY002

R

An Account Payment statement based on a Payment made via the Accounts > Process Payments screen in Back Office.

 


Related Topics

 

  1. Accounts
  2. Reports