--- title: Quickbooks Desktop description: Quickbooks Desktop --- [Skip to content](https://help.clubspeed.com/clubspeed-knowledge-center/quickbooks-desktop#main-content) English Show submenu for translations [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new?hsLang=en) [![Clubspeed Logo](https://help.clubspeed.com/hs-fs/hubfs/Logo_Grey.png?width=500&height=86&name=Logo_Grey.png)](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en) Open main navigation Close main navigation - English Show submenu for translations - [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new) - [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6) [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6) How can we help you? - There are no suggestions because the search field is empty. 1. [Clubspeed Customer Knowledge Center](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en) 2. [Reporting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en) 3. [Quickbooks Online](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#quickbooks-online) November 14, 2024 # Quickbooks Desktop **Overview** Club Speed provides a flexible export system that allows for custom field name replacements at export time. Mappings between Club Speed Account Name and your custom name are created by matching the AccountNumber field and then attaching any variables in the 'Replacements' section and then running the report to save/process. Account Numbers for custom accounts can be updated in your /SP\_ADMIN under 'Settings \> Advanced Settings \> Product Classes' Quickbooks Desktop is a more manual process, but much easier to setup.  --- **TABLE OF CONTENTS** - [OPTION #1 - /SP\_ADMIN EXPORT](https://support.clubspeed.com/a/solutions/articles/47001212177#OPTION-#1---/SP_ADMIN-EXPORT) - [OPTION #2 - /ADMIN DASHBOARD EXPORT](https://support.clubspeed.com/a/solutions/articles/47001212177#OPTION-#2---/ADMIN-DASHBOARD-EXPORT) --- OPTION #1 - /SP\_ADMIN EXPORT Here’s an example file snippet for the export, located in the SP\_Admin \> Reports \> Accounting \> Export section.    You will need to manually map ALL the revenue classes and tenders to a GL account in Quickbooks or the import will fail. Please refer to the [PRODUCT CLASS setup](https://support.clubspeed.com/en/support/solutions/articles/47001124696-product-classes)[article here](https://support.clubspeed.com/en/support/solutions/articles/47001124696-product-classes).   1\. Copy this to a notepad file. 2\. Change the mappings to suit the customer revenue classes and GL accounts. 3\. Then paste it back into the export field.  4\. Once the mapping is correct you can click the Export button to get your IIF file that will be imported into the customer’s Quickbooks Desktop software. \[Don't forget to select the date you wish to pull before running\]   ***NOTE:*** *This can be a trial & error process in order to get it just right. **IF** this report is not matching 100% in your Quickbooks account, you will need to 'undo' the import, make the necessary changes in the export log, and try again.* !TRNS,TRNSID,TRNSTYPE,DATE,NUMB,ACCNT,CLASS,AMOUNT,DOCNUM,MEMO !SPL,SPLID,TRNSTYPE,DATE,NUMB,ACCNT,CLASS,AMOUNT,DOCNUM,MEMO !ENDTRNS,,,,,,,,, SPL,,GENERAL JOURNAL,##DATE##,,65014 - Cash,,##CASH##,##YYYYMMDD##,Cash SPL,,GENERAL JOURNAL,##DATE##,,65010 - Amex,,##AMEX##,##YYYYMMDD##,Amex SPL,,GENERAL JOURNAL,##DATE##,,65011 - Visa,,##VISA##,##YYYYMMDD##,Visa SPL,,GENERAL JOURNAL,##DATE##,,65012 - Master Card,,##MC##,##YYYYMMDD##,MC SPL,,GENERAL JOURNAL,##DATE##,,65013 - Discover,,##DISC##,##YYYYMMDD##,Discover SPL,,GENERAL JOURNAL,##DATE##,,65015 - Check,,##CHECK##,##YYYYMMDD##,Check SPL,,GENERAL JOURNAL,##DATE##,,65019 - Gift Certificates,,##GIFTCARD##,##YYYYMMDD##,Gift Card SPL,,GENERAL JOURNAL,##DATE##,,65018- Voucher,,##VOUCHER##,##YYYYMMDD##,Voucher SPL,,GENERAL JOURNAL,##DATE##,,65017 - Comps,,##COMPLIMENTARY##,##YYYYMMDD##,Complimentary SPL,,GENERAL JOURNAL,##DATE##,,65016 - Debit,,##DEBITCARD##,##YYYYMMDD##,Debit SPL,,GENERAL JOURNAL,##DATE##,,65070 - Memberships,,##CLASS2##,##YYYYMMDD##,Sales By Classes SPL,,GENERAL JOURNAL,##DATE##,,87000 - Karting,,##CLASS1##,##YYYYMMDD##,Sales By Classes SPL,,GENERAL JOURNAL,##DATE##,,65020 - Sales Tax,,##TAXES##,##YYYYMMDD##,Sales Taxes SPL,,GENERAL JOURNAL,##DATE##,,Discounts - 99999,,##DISCOUNT1##,##YYYYMMDD##,Item Discount SPL,,GENERAL JOURNAL,##DATE##,,Discounts - 99999,,##DISCOUNT2##,##YYYYMMDD##,Check Discount SPL,,GENERAL JOURNAL,##DATE##,,Prepayments - 99999,,##PREPAYMENTS##,##YYYYMMDD##,PrePayments SPL,,GENERAL JOURNAL,##DATE##,,Prepayments Used - 99999,,##PREPAYMENTSUSED##,##YYYYMMDD##,PrePayments Used                                 SPL,,GENERAL JOURNAL,##DATE##,,Over Paid - 99999,,##OVERPAID##,##YYYYMMDD##,Over Payment SPL,,GENERAL JOURNAL,##DATE##,,Gift Card Sales - 99999,,##GIFTCARDSALES##,##YYYYMMDD##,Sales GiftCard SPL,,GENERAL JOURNAL,##DATE##,,Expenses Out - 99999,,##EXPENSEOUT##,##YYYYMMDD##,Expense Out SPL,,GENERAL JOURNAL,##DATE##,,Expenses In - 99999,,##EXPENSEIN##,##YYYYMMDD##,Expense In ENDTRNS,,,,,,,,, ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47193747238/original/6Z8lv5Vd_D2MydFiL9sZaqc0cL3NVCKVXw.jpeg?1673286126)    ---   #### **OPTION #2 - /ADMIN DASHBOARD EXPORT** In your /ADMIN dashboard, navigate to Reports \> Accounting Export. You will need to map all of your GL accounts in the REPLACEMENTS field.    **Usage Examples** Variables may be appended by separating them with the pipe character '|' and the format: VARIABLE=VALUE. Example: ##CASH\_PAYMENT##=4010|Class=My Class This maps the ##CASH\_PAYMENT## account to account number 4010 and also assigns the variable 'Class' the value of 'My Class'. Each time you run the export, the Replacement Mappings are saved. The exported date format default may be overridden with the 'Date\_Format' variable using PHP date() options. Example: ##CASH\_PAYMENT##=4010|Date\_Format=d/m/Y **Pre-defined Account Names** - ##CASH\_PAYMENT## - ##COMPLIMENTARY\_PAYMENT## - ##GIFT\_CARD\_&\_FAST\_CASH\_PAYMENT## - ##\_EXTERNAL\_PAYMENT## - ##ITEM\_DISCOUNT## - ##TAXES## - ##PREPAYMENTS## - ##PREPAYMENTS\_USED## - ##EXPENSES## - ##GIFTCARDS## - ##GRATUITY## - ##FEE## - ##CHECK\_DISCOUNT## - *Plus any custom payment types and accounts* **Quickbooks Variables** - Class Example: ##CASH\_PAYMENT##=4010|Class=My Class   **![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47193746707/original/zHdDjxpHON9zqXKg8kvmBxYvLjFMjC2mPg.jpeg?1673285967)** **RUN REPORT** - **Choose your export file type in the top right.** - **Import into your Quickbook program** **![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47193746808/original/wrO8quITm1R7gOzIYSeczAFh7mJpzFDIkQ.png?1673285998)** - [FAQs](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#main-content) - [Software Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#software-questions) - [Payments Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#payments-questions) - [Getting started](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#main-content) - [Clubspeed](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#clubspeed) - [Administration](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#administration) - [Product Setup](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#product-setup) - [Customer Experience](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#customer-experience) - [Race Control](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control) - [Manager Controls](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#manager-controls) - [Point of Sale Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#point-of-sale-operations) - [Venue Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#venue-operations) - [Race Control Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control-operations) - [Event Calendar](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#event-calendar) - [Open & Closing Shifts](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#open-closing-shifts) - [Activity Setup (FEC Non Karting)](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#activity-setup-fec-non-karting) - [Kart Focused](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#kart-focused) - [Troubleshooting](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#main-content) - [networking](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#networking) - [General](https://help.clubspeed.com/clubspeed-knowledge-center/general?hsLang=en) - [Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#main-content) - [Gift Cards](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#gift-cards) - [Integrations](https://help.clubspeed.com/clubspeed-knowledge-center/integrations?hsLang=en) - [Payments](https://help.clubspeed.com/clubspeed-knowledge-center/payments?hsLang=en) - [Email and Text Messaging](https://help.clubspeed.com/clubspeed-knowledge-center/email-and-text-messaging?hsLang=en) - [Item Management](https://help.clubspeed.com/clubspeed-knowledge-center/item-management?hsLang=en) - [Resources](https://help.clubspeed.com/clubspeed-knowledge-center/resources?hsLang=en) - [Calendar Management](https://help.clubspeed.com/clubspeed-knowledge-center/calendar-management?hsLang=en) - [Customer Management](https://help.clubspeed.com/clubspeed-knowledge-center/customer-management?hsLang=en) - [Promotions and Marketing](https://help.clubspeed.com/clubspeed-knowledge-center/promotions-and-marketing?hsLang=en) - [Updates](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#main-content) - [Release Notes](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#release-notes) - [Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#main-content) - [Setting up Your Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#setting-up-your-registration) - [iPads](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#ipads) - [Products](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#main-content) - [Business Additions](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#business-additions) - [Extra Tips & Tricks](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#extra-tips-tricks) - [Setup](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#setup) - [Point of Sale](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#point-of-sale) - [Barcode](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#barcode) - [Activities](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#main-content) - [Activity Operations](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#activity-operations) - [Reporting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#main-content) - [Sales Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#sales-reports) - [Operational Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#operational-reports) - [Labor Report](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#labor-report) - [Accounting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#accounting) - [Race Operations](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#race-operations) - [Quickbooks Online](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#quickbooks-online) - [Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#main-content) - [Setup - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#setup-club-booking) - [Operations](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#operations) - [Booking Manager](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#booking-manager) - [Bonus Material - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#bonus-material-club-booking) - [Operational Flows](https://help.clubspeed.com/clubspeed-knowledge-center/operational-flows?hsLang=en) - [Food & Beverage](https://help.clubspeed.com/clubspeed-knowledge-center/food-beverage?hsLang=en) - [Speed Screen Displays](https://help.clubspeed.com/clubspeed-knowledge-center/speed-screen-displays?hsLang=en) - [Garage](https://help.clubspeed.com/clubspeed-knowledge-center/garage?hsLang=en) - [Support Task](https://help.clubspeed.com/clubspeed-knowledge-center/support-task?hsLang=en) - [Webinar](https://help.clubspeed.com/clubspeed-knowledge-center/webinar?hsLang=en) - [Playbook](https://help.clubspeed.com/clubspeed-knowledge-center/playbook?hsLang=en) [![2022-clubspeed-newsletter-header-logo](https://help.clubspeed.com/hs-fs/hubfs/2022-clubspeed-newsletter-header-logo.png?width=240&height=42&name=2022-clubspeed-newsletter-header-logo.png "2022-clubspeed-newsletter-header-logo")](https://help.clubspeed.com/?hsLang=en) Copyright © 2024, Club Speed, LLC