Need Help With Accountant's Copy and Accountant's Entries

I have a copy of a client's Sage 50 file... it's an accountant's copy that I got from them. I've been working with that file, and when I was ready, I exported my journal entries, which I then in turn imported into their version of Sage.

Next I exported a fresh accountant's copy to do some more work, and again, as the time was right, exported my entries again, and imported them into the client's file.

This has been working for the most part however, I'm noticing that some of my entries that I'm importing, are doubling up. I'm clearly missing a step.

For example, I posted money my client received by e-transfer (this is a non-profit, so there are no invoices) as my client forgot to post this, and in order to get her bank rec to reconcile, I made a journal entry.

Dr. 1060 Bank                            $3,000.00

          Cr. 4040 Non-receipted donations         $3,000.00

There are now duplicates of this entry in her 'live' file... I've voided the extra journal entry, but this has happened a number of times now. So I'm clearly doing something wrong.

Is anyone able to shed light on this?

Thanks in advance,

Kristine

  • 0

    Hi Kristine:

    Sorry I missed this posting earlier. I do not use the Accountant's Copy of a client's file. However, if I remember correctly, you are able to make general journal entries directly into the Accountant's Copy. When you are finished, send the Accountant's Copy back to your client for them to import into their copy. This should not create duplicate entries. There use to be one major issue with the Accountant's Copy and I have not heard of it being remedied. The Accountant's Copy does not allow any changes to the Accounts Receivable or Accounts Payable as these are controlled accounts they must be changed through the appropriate module. HTH 

  • 0 in reply to Alwyn

    No worries and thank you. 

    I'd be interested in hearing what that unresolved issue was pertaining to the Accountant's Copy... I'll see if I can dig around the forums a bit deeper for that.

    I agree that there shouldn't be duplicate entries... I must be doing something wrong, but I'm not sure what. I've imported the entries into a client's file before, and not had this issue, but now it's happened with two clients. I must be forgetting something, but honestly, I can't recall what, and thus I'm looking for more help.

    Seems like the "Help" section of Sage is very basic in its instructions, and there isn't any info re troubleshooting the importing of journal entries.

    At least you've shared that there was once a major issue with Accountant's Copy, that gives me something to chew on... who knows, as I drill down on that item, I may come across my solution Slight smile

    Thanks again for your reply!

    Best,

    Kristine

  • 0 in reply to Kristine Griba

    Kristine: as i mentioned only make your entries in the Accountant's Copy. Do not send them separately to your client. When you are finished, then return the Accountant's Copy to your client. When the client then imports to Accountant's Copy it will make all entries required in the client file. No need for a second import of your entries separately. The Accountant's Copy must be returned to your client for them to close the loop as Sage is waiting to get the copy back and the final upload looks after this.

    The concern I mentioned is with accountants wanting to make changes to A/R and A/P which they can do through the use of the Accountant's Copy but it does not affect the A/R or A/P module. These changes must be made directly to the customer/vendor ledgers to maintain the necessary balance in the module with the account balance.

  • 0 in reply to Alwyn

    Right... so what we typically do is we get the Accountant's Copy from our clients, do the work we need on our local PCs, and then export those journal entries. Next, we then email the exported journal entries to our client using a secure file transfer system. Next, we log into our client's computer using TeamViewer, and in their 'live' Sage file import the journal entries we sent them securely (because most of them are unable to do that.)

    We do this each month for some of our clients' monthly bookkeeping needs.

    I'm finding when I go to get our client's Accountant's Copy for the next bookkeeping month, I'm seeing duplicates of the journal entries of what we imported the prior month... it's like they get imported twice. We do not return the actual Accountant's Copy Sage file since we are emailing them the journal entries for importing.

    Initially I thought maybe I had emailed the client the wrong file of exported journal entries... like one from a prior month. But since the first time I noticed these duplicates, I've been taking extra care to make sure I'm importing the correct file.

    Anyway, my research continues.

    Thanks again, Alwyn.