Skip to content

QuickBooks DSN File. What are these and how to bring them to use

    QuickBooks dsn file

    Whether you are a new user or an old user, you need to know how you can associate your company file with QuickBooks. There are very few reasons where QuickBooks makes ancillary files that are based on your company file otherwise users need to utilize window explorer manually to read the QuickBooks data. These files are necessary to support the data files. Through this file, you can easily connect your company file with QuickBooks. Learn with this blog how to use the QuickBooks DSN file, it will save your time instead to make a copy and then paste the files into QuickBooks.

    Go Through With The More QuickBooks Windows Files

    File Extension

    File Type



    QuickBooks Report Template File

    If you need to export the customized form templates, then QB requires you to create a file with .qbr


    QuickBooks Web Connector File

    For the utilization of the QuickBooks web connector then you need to open through apps. If third-party create the app then they need to create the new file with .qwc extension


    Layout Designer Template File

    If you need to export a customized form template, then QuickBooks creates a new file with .des extension. .QuickBooks offers many templates


    US Tax table File

    If you run the payroll in QuickBooks then you need this file to view the current tax table.

    Details of QuickBooks DSN File and How to Bring Them to Use

    QuickBooks DNS file is basically categorized into three different file types. They are as follows:

    • .QBW, is used for all major working files
    • .QBB, and .QBM, is meant for backup file types
    • .ND, .DSN, and TLG, is meant for database support files

    QuickBooks is no different than any other software, like others it also reads the data file:

    QuickBooks Filename.qbw

    The .qbw file extension is usually term as QuickBooks company file, company data file or sometimes as QuickBooks file. It is the principal data file that works as company financial records storehouse. All your data files are saved by QuickBooks. If you want to find the saved company files and its location:

    • Start your QuickBooks
    • Open the company file
    • Now press on F2 keys
    • The Product Information page will be displayed to you

    In the Product Information Page, you will be able to view all the important information about QuickBooks and the data, including the File Location of your data. If you want to create a backup for the company data, utilize the internal backup function.

    • Go to File
    • Click on Back Up/Create Copy.

    Backup File Types .QBB And .QBM

    When creating QuickBooks data back up, you will be given two options for back up:

    The .QBB:This file type will create a backup for the QuickBooks QBW file. The important financial company data along with logos, templates, images, and letters are stored properly. It is best to regularly back up all the QuickBooks data.

    The .QBM: This is the compressed and portable version, particularly meant for QuickBooks QBW financial data. Logos or Template or logos are not included in this. The QBM file is especially used when there is a need to share only financial data because of compressed file size.

    The .QBB and .QBM file types also function as a zipped file, where you can restore if you lose the company data file or gets corrupted.

    ➤ Database Support Files: .DSN, .ND, and .TLG

    The Database support files do not require to access directly.

    ⛔ .DSN: DSN indicates the name of the Data Source. It is a text file that includes all the information required by the QuickBooks program to access the QuickBooks company file.

    .ND: ND indicates the Network Data. A config. file which enables you access to QuickBooks company file.

    ⛔ .TLG: TLG indicates the Transaction Log. Log file maintains track of all the changes made in the file starting from the last backup.

    The 1-2-3 File Menu Structure Of QuickBooks File Extensions

    Main Working File (.QBW) – This file is created by the administrator and then saved in the windows folder

    Backup File Types (.QBM, QBB) – This file created by the user, and you can save that data in the additional storage device

    Database Support Files (.ND, DSN, TLG) – These files are auto-created by the system

    Final Words

    The above data is all you need to know about the QuickBooks DSN files including all their benefits and utilization. If you want to know more or need any kind of help or advice, get in touch with QuickBooks expertise via Sage customer online services or type your all queries to this email address [email protected]. The team of QuickBooks expertise fixes your all issues to find better results and take care of every single issue related to Sage.