Financial Reports
Financial Exports
FWS has a powerful feature that will print Consignor checks automatically under Auction Application/Consignment/Print Checks. Once these checks are produced they can be imported directly into your Quickbooks program without having to individually key every check - a huge time savings for the accounting department! In FWS there are two ways to do this: by using a 3rd party program like Transaction Pro (Option 1) or by using the Quickbooks import file protocol (Option 2)
Option 1: CSV Checks Import
- Select the list view
for the auction you wish to download. Select date range for export. This will initiate a CSV download that will include pre-formatted upload for the Transaction Pro import program that works in conjunction with Quickbooks.
Option 2: Quickbooks Checks Export
- Select the list view
- Under Settings/Invoice-Payment Defaults/Quickbooks Settings, if the ckeckbox labeled "Include Deposit Records for Buyer payments" is YES, the Quickbooks export will include all records for Buyer payments as well as records for Consignor payments.
End of Day Payments Received
- Lists all of the payments and type for the date range specified
All Accounts Receivable
- Lists all auctions that have any balance-due amounts owed. Select the individual auction for buyer/auction details and contact information. Exportable into a CSV file
Select "eyeball" icon to view detail for any auction: Choose to view All Invoices, or just the Unpaid Invoices
Following is an example of
