Sign in
Polyphone Forum

1-817-752-4983 Easiest way to share QuickBooks Desktop files

Category: Support & bug reports
  • Ni 2 0
    Message from Nipil24972 on
    [font="Times New Roman", serif]Sharing a company file the wrong way is how most businesses end up with duplicate versions, lost entries or a corrupted file. If you are not sure which sharing method fits your team, call [/font][font="Times New Roman", serif]+1-817-752-4983[/font][font="Times New Roman", serif] and get the setup right before two people start working in separate copies.[/font]
    [font="Times New Roman", serif]The Easiest Way to Share QuickBooks Desktop Files[/font]
    [font="Times New Roman", serif]There is no single easiest method, because sharing a company file means four different things. Two people entering transactions at once is a different problem from handing your accountant a copy, which is different again from sending someone last quarter's numbers.[/font]
    [font="Times New Roman", serif]This guide matches each situation to the simplest method that actually works, explains the file types involved and covers what to do when sharing breaks. [/font]
    [font="Times New Roman", serif]What Kind of Sharing Do You Need? 1-817-752-4983[/font]
    [font="Times New Roman", serif]Start here. Choosing the wrong method is what creates duplicate files and lost work.[/font]

    [th][font="Times New Roman", serif]Situation[/font][/th]
    [th][font="Times New Roman", serif]Simplest method that works[/font][/th]
    [font="Times New Roman", serif]Two or more staff entering transactions at the same time[/font][font="Times New Roman", serif]Multi-user mode over a local network[/font]
    [font="Times New Roman", serif]Your accountant needs to make year-end adjustments[/font][font="Times New Roman", serif]Accountant's Copy[/font]
    [font="Times New Roman", serif]A bookkeeper works from home[/font][font="Times New Roman", serif]Cloud hosting or remote desktop[/font]
    [font="Times New Roman", serif]Someone needs a copy to review, not to change[/font][font="Times New Roman", serif]Backup or portable company file[/font]
    [font="Times New Roman", serif]A lender or partner wants the numbers[/font][font="Times New Roman", serif]Exported reports as PDF or Excel[/font]
    [font="Times New Roman", serif]You are moving the file to a new computer[/font][font="Times New Roman", serif]Backup file[/font]



    [font="Times New Roman", serif]Which File Type Should You Send?[/font]
    [font="Times New Roman", serif]QuickBooks Desktop uses several file types, and picking the wrong one causes most sharing confusion.[/font]

    [th][font="Times New Roman", serif]Extension[/font][/th]
    [th][font="Times New Roman", serif]What it is[/font][/th]
    [th][font="Times New Roman", serif]Use it to[/font][/th]
    [font="Times New Roman", serif].QBW[/font][font="Times New Roman", serif]The live company file[/font][font="Times New Roman", serif]Work in QuickBooks; not for emailing[/font]
    [font="Times New Roman", serif].QBB[/font][font="Times New Roman", serif]A backup[/font][font="Times New Roman", serif]Move or restore a complete file[/font]
    [font="Times New Roman", serif].QBM[/font][font="Times New Roman", serif]A portable company file[/font][font="Times New Roman", serif]Send a compact copy[/font]
    [font="Times New Roman", serif].QBX / .QBA / .QBY[/font][font="Times New Roman", serif]Accountant's Copy files[/font][font="Times New Roman", serif]Let an accountant work while you keep working[/font]
    [font="Times New Roman", serif].ND and .TLG[/font][font="Times New Roman", serif]Supporting network and log files[/font][font="Times New Roman", serif]Nothing; QuickBooks manages these[/font]



    [font="Times New Roman", serif]One rule prevents a lot of grief: the live .QBW file is not a document you copy around. Everything you send to someone else should be a backup, a portable file or an Accountant's Copy.[/font]
    [font="Times New Roman", serif]How Do You Share With People in the Same Office?[/font]
    [font="Times New Roman", serif]Multi-user mode is the only method that lets several people work in the same file at once. The file lives on one computer, and everyone else connects to it.[/font]
    [font="Times New Roman", serif]Setting It Up[/font]
    1. [font="Times New Roman", serif]Choose the computer that will hold the file. A machine that stays on, wired to the network, works best.[/font]
    2. [font="Times New Roman", serif]Install QuickBooks Database Server Manager on that computer, matching your QuickBooks version year.[/font]
    3. [font="Times New Roman", serif]Put the company file in a shared folder on that machine's local drive.[/font]
    4. [font="Times New Roman", serif]Scan the folder in Database Server Manager so workstations can find the file.[/font]
    5. [font=Calibri, sans-serif][font="Times New Roman", serif]On the hosting computer only, turn on [/font][font="Times New Roman", serif]File > Utilities > Host Multi-User Access[/font][font="Times New Roman", serif].[/font][/font]
    6. [font="Times New Roman", serif]On each workstation, open the file across the network and confirm it opens in multi-user mode.[/font]
    [font="Times New Roman", serif]Licensing matters here. Each person working in the file at the same time needs their own user license, so a three-person office needs three seats.[/font]
    [font="Times New Roman", serif]When Sharing Stops Working[/font]
    [font="Times New Roman", serif]Network sharing fails in predictable ways, and the message that [/font][font="Times New Roman", serif]QuickBooks cannot connect to the company files[/font][font="Times New Roman", serif] usually points to one of four causes rather than to a damaged file. Check them in this order: 1-817-752-4983[/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Hosting is in the wrong place.[/font][font="Times New Roman", serif] Hosting should be enabled on the computer holding the file and off on every workstation. Enabling it in more than one place causes conflicts.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]The database service is not running.[/font][font="Times New Roman", serif] On the hosting computer, confirm the QuickBooksDBXX service and QBCFMonitorService are running and set to start automatically.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Folder permissions are too tight.[/font][font="Times New Roman", serif] Every QuickBooks user needs full access to the folder holding the file, not just to the file itself.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Security software is blocking the connection.[/font][font="Times New Roman", serif] Add firewall rules for the QuickBooks programs and the ports your version uses, and exclude the company file folder from real-time scanning.[/font][/font]
    [font="Times New Roman", serif]If none of those resolve it, copy the file to a workstation's local drive and open it there. Opening cleanly confirms the problem is the network or the host, not the file.[/font]
    [font="Times New Roman", serif]How Do You Share With Your Accountant?[/font]
    [font="Times New Roman", serif]The following are the main ways to share your QuickBooks Desktop file with your accountant, depending on the type of work they need to perform:[/font][font="Times New Roman", serif] [/font]
    [font="Times New Roman", serif]Accountant's Copy[/font]
    [font="Times New Roman", serif]This is the method built for the job. You set a dividing date, QuickBooks creates a file for your accountant, and you keep working in the meantime. Your accountant adjusts transactions dated before the dividing date, then sends back a change file you import.[/font]
    [font="Times New Roman", serif]The trade-offs are worth knowing before you choose it:[/font]
    • [font="Times New Roman", serif]You cannot change transactions dated on or before the dividing date while the Accountant's Copy is outstanding.[/font]
    • [font="Times New Roman", serif]Some activities are restricted, including certain list changes and reconciling periods that overlap the dividing date.[/font]
    • [font="Times New Roman", serif]Your accountant generally needs an Accountant edition of the same version year or newer.[/font]
    • [font="Times New Roman", serif]The restriction stays until you import the changes or cancel the Accountant's Copy, so agree on a deadline.[/font]
    [font="Times New Roman", serif]When to Send a Backup Instead[/font]
    [font="Times New Roman", serif]Send a backup when your accountant needs full access, such as during cleanup work or a file review, or when the work spans dates on both sides of a dividing date. The catch is that you should stop entering transactions while they work, because their copy becomes the current file when it comes back. Agree in advance on who is working in the file and when.[/font]
    [font="Times New Roman", serif]The External Accountant User[/font]
    [font="Times New Roman", serif]For an accountant who works in your live file, create an External Accountant user rather than sharing the admin login. It grants broad access while keeping their activity separate in the audit trail, and it protects sensitive customer payment details.[/font]
    [font="Times New Roman", serif]How Do You Share With Someone Working Remotely?[/font]
    [font="Times New Roman", serif]The following are the main options for sharing a QuickBooks Desktop file with someone working remotely:[/font][font="Times New Roman", serif] [/font]
    [font="Times New Roman", serif]Cloud Hosting[/font]
    [font="Times New Roman", serif]An authorized hosting provider runs QuickBooks Desktop on a server you and your team reach from anywhere, with real multi-user access. This is the simplest option for a distributed team, and the provider handles backups, patching and security. The cost is billed per user each month on top of your QuickBooks subscription. 1-817-752-4983[/font]
    [font="Times New Roman", serif]Remote Desktop[/font]
    [font="Times New Roman", serif]Connecting to the office computer remotely works for one or two people and costs nothing extra. Keep remote desktop behind a VPN or managed gateway rather than exposing it to the internet, and require multifactor authentication, since exposed remote desktop is among the most common paths to ransomware.[/font]
    [font="Times New Roman", serif]Why Not Consumer File Sync?[/font]
    [font="Times New Roman", serif]Putting a live company file in a folder synced by a consumer cloud service is the most common sharing mistake. The service copies the file while QuickBooks has it open, which corrupts company files, and two people working in synced copies create conflicting versions with no way to merge them. Use those services for backups only.[/font]

    [font="Times New Roman", serif]Security & Compliance Best Practices[/font]
    [font="Times New Roman", serif]A QuickBooks company file contains your business's most sensitive information—including bank account numbers, payroll records, Social Security numbers, and tax IDs. Leaving this file exposed during transfer can result in severe data breaches, fraud, or costly regulatory compliance penalties.[/font]
    • [font="Times New Roman", serif]Never Send Files as Plain Email Attachments
      Standard email is unencrypted and easily intercepted. Sending a raw [color=#188038].QBW      , .QBB, or .QBM file via regular email exposes all your bank details and personal identifiable information (PII) to potential hackers.[/font]      [/color]
    • [font="Times New Roman", serif]Encrypt Files Before Sharing
      If you must transfer a file directly, compress it into a password-protected archive using software like 7-Zip or WinRAR. Ensure you use AES-256 encryption and share the decryption password via a separate channel (e.g., a phone call or text message), never in the same email.      [/font]
    • [font="Times New Roman", serif]Use Secure File Portals
      The safest method is uploading your file to a dedicated, encrypted portal designed for financial document exchange—such as ShareFile, SmartVault, or Intuit Link. These services encrypt your data both while transferring and while at rest.      [/font]
    • [font="Times New Roman", serif]Stay Compliant (CPAs & Bookkeepers)
      If you handle financial files for clients, regulations like SOC 2 and the FTC Safeguards Rule mandate strict safeguards for customer financial data. Using unencrypted file transfers can result in heavy non-compliance fines.      [/font]


    [font="Times New Roman", serif]How Do You Send a One-Time Copy?[/font]
    [font="Times New Roman", serif]When someone just needs a copy, choose between a backup and a portable file.[/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Backup (.QBB):[/font][font="Times New Roman", serif] Complete. Includes templates, logos and letters. Larger. Use it when the recipient needs everything, or when moving the file to another computer.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Portable file (.QBM):[/font][font="Times New Roman", serif] Compressed and much smaller, which suits transfer over a network or upload. It leaves out items such as templates, logos and letters, and it takes longer to open because QuickBooks rebuilds the file on restore.[/font][/font]
    [font="Times New Roman", serif]Whichever you send, set a password on the file, send the password through a different channel than the file itself, and use secure transfer rather than email. These files hold payroll and banking data, and emailed copies stay in inboxes indefinitely.[/font]
    [font="Times New Roman", serif]Does the Other Person Actually Need the File?[/font]
    [font="Times New Roman", serif]Before sending anything, ask what the recipient will do with it. Reading numbers and changing numbers call for completely different levels of access, and most requests turn out to be the first kind.[/font]
    [font="Times New Roman", serif]Often the easiest sharing method is not sharing the file at all. A lender wants financial statements. A partner wants to see profitability. A landlord wants proof of revenue. All of those are report exports, which take a minute and expose nothing beyond what you intend.[/font]
    [font="Times New Roman", serif]Export to PDF when the recipient only needs to read the numbers, and to Excel when they need to work with them. Send the whole file only when someone must make changes inside QuickBooks.[/font]
    [font="Times New Roman", serif]What Does This Look Like for Three Businesses?[/font]
    [font="Times New Roman", serif]The right setup depends on how many people need access to the file, where they work, and how often they need to work remotely.[/font][font="Times New Roman", serif] [/font]
    [font="Times New Roman", serif]A Two-Person Office[/font]
    [font="Times New Roman", serif]One computer holds the file, the second connects over the network in multi-user mode, and the accountant gets an Accountant's Copy each January. Nothing else is needed. The main risk is hosting the file on a laptop that closes at the end of the day, which drops the other user mid-entry.[/font]
    [font="Times New Roman", serif]An Owner Who Travels With a Bookkeeper on Site[/font]
    [font="Times New Roman", serif]The bookkeeper works in the office file. The owner connects by remote desktop through a VPN when away, or the business moves to hosting if that happens weekly. Reports go out as PDFs rather than file copies, which keeps payroll data off the road.[/font]
    [font="Times New Roman", serif]A Business With Staff in Two Cities[/font]
    [font="Times New Roman", serif]This is the case that pushes businesses to cloud hosting. Keeping the file in one office and letting the other city reach it over the internet produces slow performance and, eventually, a damaged file. Hosting or a cloud accounting product is the right answer rather than a workaround.[/font]
    [font="Times New Roman", serif]How Do You Keep Control of a Shared File? 1-817-752-4983[/font]
    [font="Times New Roman", serif]In order to keep control over the shared file following needs to be done:[/font]

    • [font=Calibri, sans-serif][font="Times New Roman", serif]Give each person a named user account,[/font][font="Times New Roman", serif] never a shared login, so the audit trail means something.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Match permissions to the role.[/font][font="Times New Roman", serif] Not everyone entering invoices needs payroll access.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Set a closing date and password[/font][font="Times New Roman", serif] so shared history cannot be altered after the books are closed.[/font][/font]
    • [font="Times New Roman", serif]Keep the admin account with one owner or manager.[/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Track what you sent and to whom,[/font][font="Times New Roman", serif] including copies sent to accountants and consultants.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Review the user list quarterly[/font][font="Times New Roman", serif] and remove people who have left.[/font][/font]
    [font="Times New Roman", serif]What Mistakes Cause the Most Trouble?[/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Two people working in two copies.[/font][font="Times New Roman", serif] Merging is not possible. One set of entries gets rekeyed.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Emailing the live .QBW file.[/font][font="Times New Roman", serif] It will not work properly and it exposes your data.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Leaving an Accountant's Copy outstanding for months,[/font][font="Times New Roman", serif] which blocks your own edits to the prior period.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Hosting the file on a laptop that sleeps,[/font][font="Times New Roman", serif] which drops everyone else's connection.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Storing the file in a synced cloud folder,[/font][font="Times New Roman", serif] the leading cause of avoidable file corruption.[/font][/font]
    • [font=Calibri, sans-serif][font="Times New Roman", serif]Sharing the admin login[/font][font="Times New Roman", serif] with a bookkeeper or consultant instead of creating a user for them.[/font][/font]
    [font="Times New Roman", serif]Frequently Asked Questions[/font]
    [font="Times New Roman", serif]Can two people work in a portable or backup copy at once?[/font]
    [font="Times New Roman", serif]They can each open their own copy, but the changes cannot be merged afterward. Only multi-user mode or a hosted environment supports genuine simultaneous work in one file.[/font]
    [font="Times New Roman", serif]What if my accountant uses a newer version than I do?[/font]
    [font="Times New Roman", serif]An Accountant's Copy generally works when your accountant runs the same version year or newer, and the change file comes back to your version. Restoring a file that has been opened in a newer Desktop version, by contrast, upgrades it permanently, so confirm the method before sending anything.[/font]
    [font="Times New Roman", serif]Is a password on the backup file enough protection?[/font]
    [font="Times New Roman", serif]It helps, but treat it as one layer. Use a strong password, send it separately from the file, prefer secure transfer over email, and delete copies you no longer need from shared drives and inboxes.[/font]
    [font="Times New Roman", serif]How do I take back access after someone has finished?[/font]
    [font="Times New Roman", serif]Deactivate their user account in QuickBooks, remove their remote access or hosting account, change any password they knew, and ask them to delete copies they hold. For an Accountant's Copy, import the changes or cancel it so the restriction lifts.[/font]
    [font="Times New Roman", serif]Can I share one file between two office locations?[/font]
    [font="Times New Roman", serif]Not over a standard internet connection with the file in one office. That setup causes slowness and file damage. Use cloud hosting, remote desktop into the machine holding the file, or move to a cloud product.[/font]
    [font="Times New Roman", serif]Does sharing require everyone to have the same QuickBooks version?[/font]
    [font="Times New Roman", serif]Yes for multi-user access. All workstations need the same version year and release, and the Database Server Manager on the hosting computer must match. Mixed versions cause connection errors that look like network problems. 1-817-752-4983[/font]

Sign in or register to take part in discussions.

Polyphone needs you!

Polyphone is free but there are costs associated with its website and development. A small donation will help a lot.

Donate
Learn the basics Try a tutorial
Scroll to
top