Recent Searches

No recent searches

    Popular Articles

      Articles
      View all
        Topics
        View all
          Tickets
          View all
            no results

            Sorry! nothing found for

            Report Field Definitions - Purchase Orders

            Modified on Wed, 27 May at 3:58 PM

            Purchase reports in WorkGuru manage your outward spending and supplier relationships, giving you a clear view of what you've ordered and what you owe. They are used to track the status of purchase orders, verify that all ordered materials have actually arrived, and monitor how much you are spending with specific vendors. By reviewing these, you can keep project costs in check, ensure you aren't being overcharged, and confirm that all supplier bills are accounted for and ready for payment.


            TABLE OF CONTENTS



            Lines by Invoice Date Pivot Report

            This report rolls up all purchase order lines for purchase orders issued within the selected period into one tidy pivot-style view. It’s a solid go-to when you want the full picture of purchasing activity over time — what was ordered, what was received, what was invoiced, and how it all lines up financially.

            Because it works at the line level, it’s especially useful for deeper analysis: spotting trends, checking supplier performance, and reconciling order values against invoices without hopping between individual purchase orders.


            FieldNotes/Expected ValuesDescription
            ADHOCNo, Yesline Item type is ADHOC 
            BASECURRENCYAUD, USD, ETCPO base currency
            BASECURRENCYINVOICEPRICEdollar valuePO base currency invoiced price
            BASECURRENCYINVOICETOTALdollar value PO base currency invoice price total
            BASECURRENCYORDERPRICEdollar value PO base currency order price
            CATEGORYtextproduct category
            CURRENCYAUD, USD, ETC PO currency
            DATEYYYY/MM/DDPO creation date
            DAYnumerical value PO creation date day
            DAYOFWEEKtextPO creation date day name
            EXCHANGERATEdollar value PO currency exchange rate
            EXPECTEDDATEYYYY/MM/DD PO expected date
            GLACCOUNTnumerical value PO GL account
            INVOICEDATEDD/MM/YYYYPO invoice date
            INVOICEDTOCLIENTdollar valuePO total invoiced amount
            INVOICENOText, Cancelled, N/APO invoice number
            INVOICEPRICEdollar value PO invoice line price
            INVOICETOTALdollar valuePO invoice total
            LINEDESCRIPTIONtextpurchase line item description
            LINESUPPLIERCODEnumerical valuepurchase line item supplier code
            LINETOTALINVOICEDORORDEREDdollar value actual cost (if invoiced) or estimated cost (if ordered), rounded to the nearest cent. 
            LINETOTALRECEIVEDORORDEREDdollar value actual cost (if received) or estimated cost (if ordered), rounded to the nearest cent. 
            LINETYPEtextpurchase line item type (e.g. Product)
            ORDERPRICEdollar value PO line item order price
            ORDERQUANTITYnumerical valuePO line item order quantity
            PODESCRIPTIONtextPO description
            PRODUCTtext-textPO line item SKU/product name
            PRODUCTNAMEtextPO line item product name
            PRODUCTSKUtextPO line item SKU
            PRODUCTTRACKINGTYPENonstock, FIFO, Batch, Serialproduct tracking type
            PROJECTMANAGERtextrelated transaction (e.g. project for project POs) project manager name
            PROJECTNAMEtextrelated transaction name
            PROJECTNOnumerical valuerelated transaction number
            QTRmonth-monthpurchase due quarter
            REASONtextif stock purchase order - will advise stock, if a transaction (e.g. project) purchase order - will advise transaction number
            RECEIVEDDATEDD/MM/YYYY PO received date
            RECEIVEDQUANTITYnumerical valuePO line items received quantity
            SERIALBATCHN/A, textif line item is serial/batch then it will display the number it was assigned
            SOURCECLIENTtextrelated transaction (e.g. project) client name
            STATUStextPO status (E.G. draft, approved, etc)
            SUPPLIERADDRESStextPO supplier address
            SUPPLIERCITYtextPO supplier city 
            SUPPLIERCONTACTtextPO supplier contact
            SUPPLIERPOSTCODEnumerical valuePO Supplier postcode
            WAREHOUSEtextPO assigned warehouse
            ORDERTOTAL (sum)dollar value PO order total amount
            BASECURRENCYORDERTOTAL (sum)dollar value PO order total amount in base currency
            YEARnumerical value PO creation year
            MONTHnumerical value/text PO creation month
            SUPPLIERtextPO supplier name
            SOURCEDOCUMENTtextsource purchase order number

            Purchase Lines by Issue Pivot Report

            This report pulls together all purchase order lines for purchase orders that were issued within your selected date range and lays them out in a handy pivot-style table. It’s a great way to get a clear, top-down view of purchasing activity over time — from what was ordered, to what’s been received and invoiced, all in one place.

            Because it works at the line level, it’s especially useful when you need a bit more detail than a high-level purchases summary. Think supplier analysis, checking delivery timelines, or reconciling order values against what actually got invoiced. Clean, simple, and surprisingly powerful once you start filtering and grouping.


            FieldNotes/Expected ValuesDescription
            ADHOCNo, Yesis the line item ADHOC
            BASECURRENCYAUD, USD, ETCPO base currency 
            BASECURRENCYINVOICEPRICEdollar value PO base currency invoiced price 
            BASECURRENCYINVOICETOTALdollar value PO base currency invoice price total 
            BASECURRENCYORDERPRICEdollar value PO base currency order price 
            CATEGORYtext product category 
            CURRENCYAUD, USD, ETC  PO currency 
            DATEYYYY/MM/DD PO creation date 
            DAYnumerical value  PO creation date day 
            DAYOFWEEKtext PO creation date day name 
            EXCHANGERATEdollar value PO currency exchange rate 
            EXPECTEDDATEYYYY/MM/DD  PO expected date 
            GLACCOUNTnumerical value  PO GL account 
            INVOICEDATEDD/MM/YYYY PO invoice date 
            INVOICEDTOCLIENTdollar valuePO total invoiced amount
            INVOICENOText, Cancelled, N/A PO invoice number 
            INVOICEPRICEdollar value PO invoice line price 
            INVOICETOTALdollar value PO invoice total 
            LINEDESCRIPTIONtext purchase line item description 
            LINESUPPLIERCODEnumerical value purchase line item supplier code 
            LINETOTALINVOICEDORORDEREDdollar value actual cost (if invoiced) or estimated cost (if ordered), rounded to the nearest cent
            LINETOTALRECEIVEDORORDEREDdollar value actual cost (if received) or estimated cost (if ordered), rounded to the nearest cent
            LINETYPEtext purchase line item type (e.g. Product) 
            ORDERPRICEdollar value PO line item order price 
            ORDERQUANTITYnumerical value PO line item order quantity 
            PODESCRIPTIONtext PO description 
            PRODUCTtext-text PO line item SKU/product name 
            PRODUCTNAMEtext PO line item product name 
            PRODUCTSKUtext PO line item SKU 
            PRODUCTTRACKINGTYPENonstock, FIFO, Batch, Serial product tracking type 
            PROJECTMANAGERtext related transaction (e.g. project for project POs) project manager name 
            PROJECTNAMEtext related transaction name 
            PROJECTNOnumerical value related transaction number 
            QTRmonth-month purchase due quarter 
            REASONtext if stock purchase order - will advise stock, if a transaction (e.g. project) purchase order - will advise transaction number 
            RECEIVEDDATEDD/MM/YYYY  PO received date 
            RECEIVEDQUANTITYnumerical value PO line items received quantity 
            SERIALBATCHN/A, text if line item is serial/batch then it will display the number it was assigned 
            SOURCECLIENTtext related transaction (e.g. project) client name 
            STATUStext PO status (E.G. draft, approved, etc) 
            SUPPLIERADDRESStext PO supplier address 
            SUPPLIERCITYtext PO supplier city  
            SUPPLIERCONTACTtext PO supplier contact 
            SUPPLIERPOSTCODEtext PO Supplier postcode 
            WAREHOUSEtext PO assigned warehouse 
            ORDERTOTAL (sum)dollar value PO order total amount 
            BASECURRENCYORDERTOTAL (sum)dollar value PO order total amount in base currency 
            YEARnumerical value  PO creation year 
            MONTHnumerical value/text  PO creation month 
            SUPPLIERtext PO supplier name 
            SOURCEDOCUMENTtext source purchase order number 

            Purchase Lines by Received Date Pivot Report

            This one’s all about what actually landed in the building. The report pulls together purchase order lines for items that were received within your selected date range and rolls them up into a pivot table. It’s perfect when you’re trying to answer questions like: “What did we receive this month?”, “Which suppliers delivered on time?”, or “What stock hit the warehouse during that period?”

            Because it’s keyed off the received date (not when the PO was raised), this report lines up nicely with goods-in, stock movements, and operational reporting. Handy for ops, warehouse checks, and reconciling what’s arrived versus what’s been ordered or invoiced. Calm, clear, and very practical.


            FieldNotes/Expected ValuesDescription
            ADHOCNo, Yesline Item type is ADHOC  
            BASECURRENCYAUD, USD, ETCPO base currency 
            BASECURRENCYINVOICEPRICEdollar value PO base currency invoiced price 
            BASECURRENCYINVOICETOTALdollar value PO base currency invoice price total 
            BASECURRENCYORDERPRICEdollar value PO base currency order price 
            CATEGORYtext product category 
            CURRENCYAUD, USD, ETC PO currency 
            DATEYYYY/MM/DD PO creation date 
            DAYnumerical value  PO creation date day 
            DAYOFWEEKtext PO creation date day name 
            EXCHANGERATEdollar value PO currency exchange rate 
            EXPECTEDDATEYYYY/MM/DD  PO expected date 
            GLACCOUNTnumerical value  PO GL account 
            INVOICEDATEDD/MM/YYYY PO invoice date 
            INVOICEDTOCLIENTdollar valuePO total invoiced amount
            INVOICENOText, Cancelled, N/A PO invoice number 
            INVOICEPRICEdollar value PO invoice line price 
            INVOICETOTALdollar value PO invoice total 
            LINEDESCRIPTIONtext purchase line item description 
            LINESUPPLIERCODEnumerical value purchase line item supplier code 
            LINETOTALINVOICEDORORDEREDdollar value actual cost (if invoiced) or estimated cost (if ordered), rounded to the nearest cent
            LINETOTALRECEIVEDORORDEREDdollar value actual cost (if received) or estimated cost (if ordered), rounded to the nearest cent
            LINETYPEtext purchase line item type (e.g. Product) 
            ORDERPRICEdollar value PO line item order price 
            ORDERQUANTITYnumerical value PO line item order quantity 
            PODESCRIPTIONtext PO description 
            PRODUCTtext-text PO line item SKU/product name 
            PRODUCTNAMEtext PO line item product name 
            PRODUCTSKUtext PO line item SKU 
            PRODUCTTRACKINGTYPENonstock, FIFO, Batch, Serial product tracking type 
            PROJECTMANAGERtext related transaction (e.g. project for project POs) project manager name 
            PROJECTNAMEtext related transaction name 
            PROJECTNOnumerical value related transaction number 
            QTRmonth-month purchase due quarter 
            REASONtext if stock purchase order - will advise stock, if a transaction (e.g. project) purchase order - will advise transaction number 
            RECEIVEDDATEDD/MM/YYYY  PO received date 
            RECEIVEDQUANTITYnumerical value PO line items received quantity 
            SERIALBATCHN/A, text if line item is serial/batch then it will display the number it was assigned 
            SOURCECLIENTtext related transaction (e.g. project) client name 
            STATUStext PO status (E.G. draft, approved, etc) 
            SUPPLIERADDRESStext PO supplier address 
            SUPPLIERCITYtext PO supplier city  
            SUPPLIERCONTACTtext PO supplier contact 
            SUPPLIERPOSTCODEnumerical value PO Supplier postcode 
            WAREHOUSEtext PO assigned warehouse 
            ORDERTOTAL (sum)dollar value PO order total amount 
            BASECURRENCYORDERTOTAL (sum)dollar value PO order total amount in base currency 
            YEARnumerical value  PO creation year 
            MONTHnumerical value/textPO creation month
            SUPPLIERtext PO supplier name 
            SOURCEDOCUMENTtext source purchase order number 

            Purchase Order Summary by Issue Date Pivot Report

            Alright, let's talk about the Purchase Order Summary by Issue Date Pivot Report. Think of this one as your "money-out" command centre. It uses a pivot table to show you exactly what’s happening with your Purchase Orders based on when they were issued. The clever bit? It handles the math for you. While POTotal shows you the original amount on the order, FORECASTCOST and ACTUALCOST do the heavy lifting by converting those foreign currencies back into your base currency using the exchange rate you’ve set. It’s the easiest way to see your real-world spending without needing a calculator or a conversion chart.


            FieldNotes/Expected ValuesDescription
            BASECURRENCYAUD, USD, ETC PO base currency
            BILLABLENo/YesPO billable status
            CONTACTtextPO supplier contact name
            CREATIONDATEDD/MM/YYYYPO creation date
            CREATORtextPO user creator
            CURRENCYAUD, USD, ETC  PO supplier currency
            DATEYYYY/MM/DDPO format issue date
            DAYnumerical value   PO creation date day 
            DAYOFWEEKtext  PO creation date day name 
            DESCRIPTIONtext PO description field
            EMAILEDDATEDD/MM/YYYYPO email date
            EXCHANGERATEdollar value  PO currency exchange rate 
            EXPECTEDDATEYYYY/MM/DD  PO expected date 
            HASBEENEMAILEDNo/Yeshas PO been emailed?
            INVOICEDATEDD/MM/YYYYPO invoice date
            INVOICEDUEDATEDD/MM/YYYY PO invoice due date
            ISADVANCEDPOTrue, Falseis the PO an advanced PO?
            ISSUEDATEDD/MM/YYYYPO issue date
            NOTEStextPO note/s
            NUMBERnumerical valuePO number
            POTOTALdollar value PO total value in PO designated currency (e.g. alternate currency if relevant)
            PROJECTMANAGERtextrelated source transaction (e.g. project) manager
            QTRmonth-month  purchase due quarter 
            RECEIVEDDATEDD/MM/YYYYPO received date
            REVISIONnumerical valuePO revision number
            SENTTOACCOUNTINGNo, DD/MM/YYYYhas the PO been sent to accounting?
            SOURCEDOCDESCRIPTIONtextrelated source transaction (e.g. project) description
            SOURCEDOCDUEOREXPECTEDDATEDD/MM/YYYYrelated source transaction (e.g. project) due or expected date
            SOURCEDOCNAMEtextrelated source transaction (e.g. project) name
            SOURCEDOCSTATUStextrelated source transaction (e.g. project) status
            SOURCEDOCUMENTtextrelated source transaction (e.g. project) number
            SUPPLIERINVOICENUMBERnumerical valuePO supplier invoice number
            TOTALdollar value PO total value excluding tax
            TOTALINCTAXdollar value PO total value including tax
            TOTALTAXdollar valuePO total tax
            WAREHOUSEtext  PO warehouse
            YEARnumerical value   PO creation year
            FORECASTCOST (sum)dollar value PO forecast cost
            ACTUALCOST (sum)dollar valuePO actual cost
            MONTHnumerical value/text  PO creation month 
            SUPPLIERtextPO supplier name 
            STATUStextPO status (E.G. draft, approved, etc) 
            DISPLAYNUMBERnumerical valuePO number + revision

            Purchase Order Summary by Invoice Date Pivot Report

            This report is your go-to for seeing exactly what's hitting the books and when. It takes all your purchase order info and bundles it up based on the invoice date, giving you a clear view of your financial commitments for any given period. It's a lifesaver for matching up your spending with your actual accounting dates rather than just when you hit "order." The best part is that it does the heavy lifting on the currency side. While POTotal keeps it real in whatever currency you used for the order, FORECASTCOST and ACTUALCOST automatically flip those values into your base currency. It means you can see your total spend across different suppliers without having to mess around with a calculator and exchange rates.


            FieldNotes/Expected ValuesDescription
            BASECURRENCYAUD, USD, ETC PO base currency
            BILLABLENo/YesPO billable status
            CONTACTtext PO supplier contact name
            CREATIONDATEDD/MM/YYYY PO creation date
            CREATORtext PO user creator
            CURRENCYAUD, USD, ETC   PO supplier currency
            DATEYYYY/MM/DD PO format invoice date 
            DAYnumerical value    PO creation date day 
            DAYOFWEEKtext   PO creation date day name 
            DESCRIPTIONtext   PO description field
            EMAILEDDATEDD/MM/YYYY PO email date
            EXCHANGERATEdollar value PO currency exchange rate 
            EXPECTEDDATEYYYY/MM/DD   PO expected date 
            HASBEENEMAILEDNo/Yeshas PO been emailed?
            INVOICEDATEDD/MM/YYYY PO invoice date
            INVOICEDUEDATEDD/MM/YYYY PO invoice due date
            ISADVANCEDPOTrue, False is the PO an advanced PO?
            ISSUEDATEDD/MM/YYYY PO issue date
            NOTEStext PO note/s
            NUMBERnumerical value PO number
            POTOTALdollar value PO total value in PO designated currency (e.g. alternate currency if relevant)
            PROJECTMANAGERtext related source transaction (e.g. project) manager
            QTRmonth-month   purchase due quarter 
            RECEIVEDDATEDD/MM/YYYY PO received date
            REVISIONnumerical value PO revision number
            SENTTOACCOUNTINGNo, DD/MM/YYYY has the PO been sent to accounting?
            SOURCEDOCDESCRIPTIONtext related source transaction (e.g. project) description
            SOURCEDOCDUEOREXPECTEDDATEDD/MM/YYYY related source transaction (e.g. project) description 
            SOURCEDOCNAMEtext related source transaction (e.g. project) name
            SOURCEDOCSTATUStext related source transaction (e.g. project) status
            SOURCEDOCUMENTtext related source transaction (e.g. project) number
            SUPPLIERINVOICENUMBERnumerical value PO supplier invoice number
            TOTALdollar value PO total value excluding tax
            TOTALINCTAXdollar value PO total value including tax
            TOTALTAXdollar value PO total tax
            WAREHOUSEtext   PO warehouse
            YEARnumerical value    PO creation year
            FORECASTCOST (sum)dollar value PO forecast cost
            ACTUALCOST (sum)dollar value PO actual cost
            MONTHnumerical value/text    PO creation month 
            SUPPLIERtext PO supplier name 
            STATUStext PO status (E.G. draft, approved, etc) 
            DISPLAYNUMBERnumerical value PO number + revision

            Purchase Order Summary by Received Date Pivot Report

            This report is all about tracking what has actually physically arrived. It takes your purchase order data and groups it by the received date, giving you a clear picture of when goods hit your warehouse or site during your chosen timeframe. It’s perfect for operational check-ins or seeing which months were the busiest for deliveries. Like the other summary reports, it does the heavy lifting on the currency side for you. While POTotal stays in the original currency you used for the supplier, FORECASTCOST and ACTUALCOST automatically convert those figures into your base currency using the exchange rate from the PO. It’s a great way to see the real-world value of the stock that’s landed without having to do the math yourself.


            FieldNotes/Expected ValuesDescription
            BASECURRENCYAUD, USD, ETC PO base currency
            BILLABLENo/YesPO billable status
            CONTACTtext PO supplier contact name
            CREATIONDATEDD/MM/YYYY PO creation date
            CREATORtext PO user creator
            CURRENCYAUD, USD, ETC   PO supplier currency
            DATEYYYY/MM/DD PO format issue date
            DAYnumerical value    PO creation date day 
            DAYOFWEEKtext   PO creation date day name 
            DESCRIPTIONtext   PO description field
            EMAILEDDATEDD/MM/YYYY PO email date
            EXCHANGERATEdollar value PO currency exchange rate 
            EXPECTEDDATEYYYY/MM/DD   PO expected date 
            HASBEENEMAILEDNo/Yeshas PO been emailed?
            INVOICEDATEDD/MM/YYYYPO invoice date
            INVOICEDUEDATEDD/MM/YYYYPO invoice due date
            ISADVANCEDPOTrue, False is the PO an advanced PO?
            ISSUEDATEDD/MM/YYYY PO issue date
            NOTEStext PO note/s
            NUMBERnumerical value PO number
            POTOTALdollar value PO total value in PO designated currency (e.g. alternate currency if relevant)
            PROJECTMANAGERtext related source transaction (e.g. project) manager
            QTRmonth-month   purchase due quarter 
            RECEIVEDDATEDD/MM/YYYY PO received date
            REVISIONnumerical value PO revision number
            SENTTOACCOUNTINGNo, DD/MM/YYYY has the PO been sent to accounting?
            SOURCEDOCDESCRIPTIONtextrelated source transaction (e.g. project) description
            SOURCEDOCDUEOREXPECTEDDATEDD/MM/YYYY related source transaction (e.g. project) due or expected date
            SOURCEDOCNAMEtext related source transaction (e.g. project) name
            SOURCEDOCSTATUStext related source transaction (e.g. project) status
            SOURCEDOCUMENTtext related source transaction (e.g. project) number
            SUPPLIERINVOICENUMBERnumerical value PO supplier invoice number
            TOTALdollar value PO total value excluding tax
            TOTALINCTAXdollar value PO total value including tax
            TOTALTAXdollar value PO total tax
            WAREHOUSEtext   PO warehouse
            YEARnumerical value    PO creation year
            FORECASTCOST (sum)dollar value PO forecast cost
            ACTUALCOST (sum)dollar value PO actual cost
            MONTHnumerical value/text    PO creation month
            SUPPLIERtext PO supplier name 
            STATUStext PO status (E.G. draft, approved, etc) 
            DISPLAYNUMBERnumerical value PO number + revision

            Purchase Order Summary by Expected Date Pivot Report

            This report groups your purchase orders by the date they are expected to arrive in your warehouse, using the issue date as a fallback if no expected date is set. It assists your business by allowing your operations team to plan for incoming stock, manage storage space, and proactively follow up with suppliers on overdue deliveries.


            FieldNotes/Expected ValuesDescription
            BASECURRENCYAUD, USD, ETC PO base currency
            BILLABLENo, Yes PO billable status
            CONTACTtext PO supplier contact name
            CREATIONDATEDD/MM/YYYY PO creation date
            CREATORtext PO user creator
            CURRENCYAUD, USD, ETC   PO supplier currency
            DATEYYYY/MM/DD PO format issue date
            DAYnumerical value    PO creation date day 
            DAYOFWEEKtext   PO creation date day 
            DESCRIPTIONtext   PO creation date day name 
            EMAILEDDATEDD/MM/YYYY PO description field
            EXCHANGERATEdollar value PO email date
            EXPECTEDDATEYYYY/MM/DD   PO currency exchange rate 
            HASBEENEMAILEDNo, Yes PO expected date 
            INVOICEDATEDD/MM/YYYY PO invoice date
            INVOICEDUEDATEDD/MM/YYYY PO invoice due date
            ISADVANCEDPOTrue, False is the PO an advanced PO?
            ISSUEDATEDD/MM/YYYY PO issue date
            NOTEStext PO note/s
            NUMBERnumerical value PO number
            POTOTALdollar value PO total value in PO designated currency (e.g. alternate currency if relevant)
            PROJECTMANAGERtext related source transaction (e.g. project) manager
            QTRmonth-month   purchase due quarter 
            RECEIVEDDATEDD/MM/YYYY purchase due quarter 
            REVISIONnumerical value PO revision number
            SENTTOACCOUNTINGNo, DD/MM/YYYY has the PO been sent to accounting?
            SOURCEDOCDESCRIPTIONtext related source transaction (e.g. project) description
            SOURCEDOCDUEOREXPECTEDDATEDD/MM/YYYY related source transaction (e.g. project) due or expected date
            SOURCEDOCNAMEtext related source transaction (e.g. project) name
            SOURCEDOCSTATUStext related source transaction (e.g. project) status
            SOURCEDOCUMENTtext related source transaction (e.g. project) number
            SUPPLIERINVOICENUMBERnumerical value PO supplier invoice number
            TOTALdollar value PO total value excluding tax
            TOTALINCTAXdollar value PO total value excluding tax 
            TOTALTAXdollar value PO total tax
            WAREHOUSEtext   PO warehouse
            YEARnumerical value    PO creation year
            FORECASTCOST (sum)dollar value PO forecast cost
            ACTUALCOST (sum)dollar value PO actual cost
            MONTHnumerical value/text    PO creation month
            SUPPLIERtext PO supplier name
            STATUStext PO status (E.G. draft, approved, etc) 
            DISPLAYNUMBERnumerical value PO number + revision

            Purchase Order Summary by Accounting Sync Date Pivot Report

            Overview

             This report tracks exactly when each purchase order was successfully transferred from WorkGuru into your accounting software (like Xero or MYOB). It assists your business by providing a clear audit trail for your bookkeeper, ensuring that all supplier bills for a specific period have been recorded and are ready for payment without any missing data.


            FieldNotes/Expected ValuesDescription
            BASECURRENCYAUD, USD, ETC PO base currency
            BILLABLENo, Yes PO billable status
            CONTACTtext PO supplier contact name
            CREATIONDATEDD/MM/YYYY PO creation date
            CREATORtext PO user creator
            CURRENCYAUD, USD, ETC   PO supplier currency
            DATEYYYY/MM/DD PO format issue date
            DAYnumerical value    PO creation date day 
            DAYOFWEEKtext   PO creation date day name 
            DESCRIPTIONtext   PO description field
            EMAILEDDATEDD/MM/YYYY PO email date
            EXCHANGERATEdollar value PO currency exchange rate 
            EXPECTEDDATEYYYY/MM/DD   PO expected date 
            HASBEENEMAILEDNo, Yes has PO been emailed?
            INVOICEDATEYYYY/MM/DD   PO invoice date
            INVOICEDUEDATEYYYY/MM/DD   PO invoice due date
            ISADVANCEDPOTrue, False is the PO an advanced PO?
            ISSUEDATEDD/MM/YYYY PO issue date
            NOTEStext PO note/s
            NUMBERnumerical value PO number
            POTOTALdollar value PO total value in PO designated currency (e.g. alternate currency if relevant)
            PROJECTMANAGERtext related source transaction (e.g. project) manager
            QTRmonth-month   purchase due quarter 
            RECEIVEDDATEDD/MM/YYYY PO received date
            REVISIONnumerical value PO revision number
            SENTTOACCOUNTINGNo, DD/MM/YYYY has the PO been sent to accounting?
            SOURCEDOCDESCRIPTIONtext related source transaction (e.g. project) description
            SOURCEDOCDUEOREXPECTEDDATEDD/MM/YYYY related source transaction (e.g. project) due or expected date
            SOURCEDOCNAMEtext related source transaction (e.g. project) name
            SOURCEDOCSTATUStext related source transaction (e.g. project) status
            SOURCEDOCUMENTtext related source transaction (e.g. project) number
            SUPPLIERINVOICENUMBERnumerical value PO supplier invoice number
            TOTALdollar value PO total value excluding tax
            TOTALINCTAXdollar value PO total value including tax
            TOTALTAXdollar value PO total tax
            WAREHOUSEtext   PO warehouse
            YEARnumerical value    PO creation year
            FORECASTCOST (sum)dollar value PO forecast cost
            ACTUALCOST (sum)dollar value PO actual cost
            MONTHnumerical value/text    PO creation month
            SUPPLIERtext PO supplier name 
            STATUStext PO status (E.G. draft, approved, etc) 
            DISPLAYNUMBERnumerical value PO number + revision

            Purchases & Accounting Potential Discrepancies Pivot Report

            This report identifies timing differences between the date goods were physically received and the date the supplier's invoice was actually dated. It assists your business by explaining why your physical stock on hand might not perfectly match your accounting balance sheet, which is essential for accurate month-end financial reporting and inventory reconciliation.


            FieldNotes/Expected ValuesDescription
            BASECURRENCYAUD, USD, ETC PO base currency
            BILLABLENo, Yes PO billable status
            CONTACTtextPO supplier contact name
            CREATIONDATEDD/MM/YYYYPO creation date
            CREATORtextPO user creator
            CURRENCYAUD, USD, ETC  PO supplier currency
            DATEYYYY/MM/DDPO format issue date
            DAYnumerical value   PO creation date day 
            DAYOFWEEKtext  PO creation date day name 
            DESCRIPTIONtext PO description field
            EMAILEDDATEDD/MM/YYYY PO email date
            EXCHANGERATEdollar value PO currency exchange rate 
            EXPECTEDDATEDD/MM/YYYYPO expected date 
            HASBEENEMAILEDNo, Yes has PO been emailed?
            INVOICEDUEDATEDD/MM/YYYY PO invoice due date
            ISADVANCEDPOTrue, Falseis the PO an advanced PO?
            ISSUEDATEDD/MM/YYYY PO issue date
            MONTHnumerical value/text   PO creation month
            NOTEStext  PO note/s
            NUMBERnumerical value PO number
            POTOTALdollar value PO total value in PO designated currency (e.g. alternate currency if relevant)
            PROJECTMANAGERtext related source transaction (e.g. project) manager
            QTRmonth-month   purchase due quarter 
            REVISIONnumerical value PO revision number
            SENTTOACCOUNTINGNo, DD/MM/YYYY has the PO been sent to accounting?
            SOURCEDOCDESCRIPTIONtext related source transaction (e.g. project) description
            SOURCEDOCDUEOREXPECTEDDATEDD/MM/YYYY related source transaction (e.g. project) due or expected date
            SOURCEDOCNAMEtext related source transaction (e.g. project) name
            SOURCEDOCSTATUStext related source transaction (e.g. project) status
            SOURCEDOCUMENTtext related source transaction (e.g. project) number
            STATUStext PO status (E.G. draft, approved, etc) 
            SUPPLIERINVOICENUMBERnumerical value PO supplier invoice number
            TOTALdollar value PO total value excluding tax
            TOTALINCTAXdollar value PO total value including tax
            TOTALTAXdollar value PO total tax
            WAREHOUSEtext   PO warehouse
            YEARnumerical value    PO creation year
            FORECASTCOST (sum)dollar value PO forecast cost
            ACTUALCOST (sum)dollar value PO actual cost
            SUPPLIERtext PO supplier name 
            DISPLAYNUMBERnumerical value PO number + revision
            RECEIVEDDATEDD/MM/YYYY PO received date
            INVOICEDATEDD/MM/YYYY PO invoice date

            Expected Profit on Received Goods Pivot Report

            This report calculates the potential profit for stock you have physically received but not yet sold, based on the difference between what you paid and your default sell prices. It assists your business by giving management a snapshot of the future revenue and gross margin currently sitting in your warehouse as available inventory.


            FieldNotes/Expected ValuesDescription
            AVERAGELANDEDCOSTdollar value PO line item average landed cost
            BASECURRENCYAUD, USD, ETC PO base currency
            BASECURRENCYINVOICEPRICEdollar valuePO line item base currency invoice price
            BASECURRENCYORDERPRICEdollar value PO line item base currency order price
            CURRENCYAUD, USD, ETC   PO supplier currency
            DEFAULTSELLPRICEdollar value PO line item product details default sell price
            DESCRIPTIONtext PO line item description
            EXCHANGERATEdollar valuePO currency exchange rate 
            EXPECTEDPROFITdollar value expected profit from PO line items
            EXPECTEDPROFITPERCENTpercentage expected profit from PO line items (percentage)
            EXPECTEDREVENUEdollar value expected revenue for line item
            NAMEtext PO line item name
            NUMBERnumerical valuePO number
            ORDERPRICEdollar value PO line item order price
            RECEIVEDPRICEdollar value PO line item received price
            RECEIVEDQTYnumerical value PO line item received quantity
            SKUnumerical value PO line item SKU
            SOURCEDOCUMENTtext related source transaction (e.g. project) name
            SUPPLIERtext PO supplier name 

            Unpaid Purchase Orders Pivot Report

            This report is your primary tool for managing outstanding liabilities. It summarizes all purchase orders that haven't been fully paid, grouped by the invoice date for your chosen period. It’s the fastest way to see exactly what you owe and when those payments are coming due, allowing you to stay on top of your accounts payable without any guesswork. The report provides a clear breakdown of your financial position by tracking the TOTALINCTAX, AMOUNTPAID, and AMOUNTOUTSTANDING for every order. It even includes helpful tracking fields like DAYSUNTILDUE and ISOVERDUE, so you can prioritize urgent payments. Whether you're reconciling with your suppliers or planning your weekly cash flow, this pivot table gives you a real-time view of your unpaid commitments in a clean, organized grid.


            FieldNotes/Expected ValuesDescription
            ACTUALCOSTdollar value PO actual cost
            BASECURRENCYAUD, USD, ETC PO base currency
            BILLABLENo, Yes PO billable status
            CONTACTtext PO supplier contact name
            CREATIONDATEDD/MM/YYYY PO creation date
            CREATORtext PO user creator
            CURRENCYAUD, USD, ETC   PO supplier currency
            DATEYYYY/MM/DD PO format invoice date 
            DAYnumerical value   PO creation date day 
            DAYOFWEEKtext  PO creation date day name 
            DAYSUNTILDUEnumerical value    PO description field
            DESCRIPTIONtext   PO email date
            EMAILEDDATEDD/MM/YYYY PO email date
            EXCHANGERATEdollar value PO currency exchange rate 
            EXPECTEDDATEDD/MM/YYYY PO expected date 
            FORECASTCOSTdollar value PO forecast cost
            HASBEENEMAILEDNo, Yes has PO been emailed?
            INVOICEDATEDD/MM/YYYY PO invoice date
            INVOICEDUEDATEDD/MM/YYYY PO invoice due date
            ISADVANCEDPOTrue, False is the PO an advanced PO?
            ISOVERDUENo, Yesis the PO overdue?
            ISSUEDATEDD/MM/YYYY PO /s
            NOTEStext PO note/s
            NUMBERnumerical value    PO number
            POTOTALdollar value PO total value in PO designated currency (e.g. alternate currency if relevant)
            PROJECTMANAGERtextrelated source transaction (e.g. project) manager
            QTRmonth-month   purchase due quarter 
            RECEIVEDDATEDD/MM/YYYY PO received date
            REVISIONmonth-month   PO revision number
            SOURCEDOCDESCRIPTIONtext related source transaction (e.g. project) description
            SOURCEDOCDUEOREXPECTEDDATEDD/MM/YYYY related source transaction (e.g. project) due or expected date
            SOURCEDOCNAMEtext related source transaction (e.g. project) name
            SOURCEDOCSTATUStext related source transaction (e.g. project) status
            SOURCEDOCUMENTtext related source transaction (e.g. project) number
            SUPPLIERINVOICENUMBERnumerical value PO supplier invoice number
            TOTALdollar value PO total value excluding tax
            TOTALTAXdollar value PO total tax
            WAREHOUSEtext PO warehouse
            TOTALINCTAX (sum)dollar value PO total value including tax
            AMOUNTPAID (sum)dollar value PO amount paid
            AMOUNTOUTSTANDING (sum)dollar value PO amount outstanding
            YEARnumerical value    PO creation year
            MONTHnumerical value/text    PO creation month 
            SENTTOACCOUNTINGNo, DD/MM/YYYY has the PO been sent to accounting?
            SUPPLIERtext PO supplier name 
            STATUStext PO status (E.G. draft, approved, etc) 
            DISPLAYNUMBERnumerical value    PO number + revision

            Was this article helpful?

            That’s Great!

            Thank you for your feedback

            Sorry! We couldn't be helpful

            Thank you for your feedback

            Let us know how can we improve this article!

            Select at least one of the reasons
            CAPTCHA verification is required.

            Feedback sent

            We appreciate your effort and will try to fix the article

            Preview
            0 of 0