TO CREATE A CREDIT CARD SALES REPORT
Credit card sales report is a financial document that summarizes the sales made through credit card transactions over a specific period. This report is typically used by businesses to track and analyze their sales performance, manage cash flow, and reconcile accounts.
User Access
Who Can Access
- Pothys admin
- Back Office
- Purchase Manager
- Manager
What User Can Do
- View Reports
- Credit Card Sales Report
Pre-Requisite Activities
- Payment Date.
Business Rules
- Data Inclusion Criteria –Transaction Type– Include only credit card transactions, excluding debit card and cash sales.
- Date Range-Allow selection of custom date ranges (e.g., daily, weekly, monthly, quarterly).
- Sales Status-Include only completed and approved transactions; exclude pending, refunded, or disputed transactions.
- Data Source–Accounting Systems: Pull data from the designated accounting or Point of Sale (POS) systems where credit card transactions are recorded.
- Payment Processors: Integrate data from payment processor platforms where credit card transactions are processed.
- Data Elements–Transaction Details: Include transaction ID, date and time of sale, customer details (if applicable), itemized list of products/services sold, total amount charged, taxes, discounts applied, and payment method.
- Calculations–Total Sales: Calculate total credit card sales within the selected date range.
- Average Transaction Value: Calculate the average value of credit card transactions by dividing total sales by the number of transactions.
- Sales by Category: Optionally categorize sales by product type or service.
- Transaction Volume: Count the number of credit card transactions over the reporting period.
- Reporting Format–Visualization: Provide options for graphs and charts (e.g., bar charts for daily sales, pie charts for sales by category).
- Export Options: Allow users to export the report in various formats (e.g., PDF, Excel, CSV) for external sharing or further analysis.
User Interface
STEP 1: To select a Credit Card Sales Report.
STEP 2: To enter a Payment date.Then to click a start check box to run the process.
STEP 3: Once to complete the process to show the report based on the given parameter.
STEP 4: Supplier code– is a unique identifier assigned to a supplier or vendor by a company or organization. It is often used in procurement and supply chain management to streamline processes such as purchasing, invoicing, and inventory management.
IGST Contraon-IGST stands for Integrated Goods and Services Tax. It is a type of indirect tax in India that is applied to the supply of goods and services when they are transported across state borders.
Document type name- typically refers to the classification or categorization of the document that contains the sales transaction details.
Document number-typically refers to a unique identifier assigned to each transaction or sale. This number is used for record-keeping and tracking purposes, helping businesses and financial institutions.
Document date – typically refers to the date on which the transaction was recorded or processed.
Buyer GSTIN– (Goods and Services Tax Identification Number) in a credit card sales report refers to the unique identification number assigned to a buyer (individual or business) who is registered under the Goods and Services Tax system in India.
Buyer legal name -typically refers to the name of the individual or business entity that appears on the credit card used for the transaction.
Buyer POS -generally refers to the point of sale (POS) transaction where a buyer uses a credit card to make a purchase.
Buyer address 1& 2- refers to the physical address of the customer who made the purchase.
Buyer location– refers to the geographical location where a credit card transaction was made.City and State, Country,Store Location.
Buyer pincode– (more commonly referred to as “buyer postal code” or “buyer ZIP code” in some regions) typically represents the postal code of the buyer’s billing address.
Buyer phone number– typically refers to the contact number of the customer who made the purchase using their credit card.
Buyer state-typically refers to the geographic location of the buyer or customer who made the purchase using the credit card.
Buyer mail ID– typically refers to the email address of the customer or buyer who made the purchase using their credit card.
Serial number-(often referred to as a transaction or reference number) typically serves as a unique identifier for each transaction. This number helps in tracking and managing sales.
Product description– refers to a detailed account of the specific credit card products that are being offered.
HSN (Harmonized System of Nomenclature) code -is a standardized numerical method of classifying goods that is internationally recognized. In the context of credit card sales reports, particularly in countries like India, the HSN code is used for identifying the nature of the goods or services sold.
Quantity-typically refers to the number of individual items or transactions that have been processed using credit cards.
Free quantity– typically refers to the number of items or units sold that are given away for free as part of a promotion or marketing strategy.
Unit– typically represents the individual items or products sold. For example, if a retailer sells 100 pairs of shoes, the unit would be “shoes,” and the total number sold would be 100 units.
Unit Price– refers to the price of each individual unit. In the previous example, if each pair of shoes is sold for $50, the unit price would be $50.
Gross amount– refers to the total revenue generated from credit card transactions before any deductions are made.
Discount– refers to a reduction in the selling price of goods or services applied to the transactions processed through credit card payments.
pretax value– in a credit card sales report refers to the total amount of sales transactions before any taxes have been applied.
Taxable value– typically refers to the portion of the sale amount that is subject to sales tax.
Goods and Services Tax (GST) rate-applied to credit card sales can vary depending on the nature of the goods or services being sold and the regulations in place in each country or region.
SGST1 -stands for State Goods and Services Tax. It is part of the Indian taxation system and applies to the sale of goods and services within a state.
CGST -stands for Central Goods and Services Tax. In the context of a credit card sales report, CGST amount refers to the portion of the Goods and Services Tax (GST) that is levied by the central government on goods and services sold.
IGST -refers to Integrated Goods and Services Tax. IGST is applicable on inter-state supply of goods and services and is a part of the Goods and Services Tax (GST) structure.
Cess Rate– In some jurisdictions, cess is an additional charge on certain products or services, often intended to fund specific initiatives (e.g., education, health, etc.).
Cess amtdval -can imply a type of tax imposed over and above the basic tax (like GST in India). The “cess amount” is the specific amount that is added to the base transaction value,AD value in this context might stand for “Added Value” or “Amount Due,” although the exact meaning.
Cess nonadv val amt- typically refers to the “cess” (a type of tax) applied to non-advancing transactions or sales that do not have an advancing or promotional value.
State cess rate-refer to taxes or levies imposed by a state government on certain transactions.
Total invoice value- typically refers to the cumulative sum of all sales transactions made using credit cards over a specific period.
Total taxable value – typically refers to the total sum of sales transactions that are subject to sales tax.
Item Total -typically refers to the total sum of the individual item prices that have been sold during a specific period.
Other charges-can refer to various fees or costs associated with credit card transactions that are not directly linked to the sale itself.
Roundoff– typically refers to the process of adjusting sales figures to the nearest whole number, often to make accounting simpler or to conform to certain financial reporting standards.
Training Videos
FAQ
SOP