Browse By Tags

  • t4

    When I print out the T4 -why is EI insurable earnings higher than employment income for 1 of our employees?
  • Reconciling Deposit Acct Bal and Prepd Ord./Deposit

    I just ran an Integrity Summary for a client of mine and everything matches except for the Deposits. Dep Bal Balance $60778.90 Prep Ord/Deposit $57379.30 I don't know why but I am at a total loss at the moment as to how to fix this. I took over…
  • Data integrity error after year end close

    We have now had 4 different pastel accounts experience this data integrity error recently. So the issue is that the current year TB is out of balance because last year's Retained earnings + profit and loss does not agree with the current year's Retained…
  • Data Inconsistency

    I keep getting a data inconsistency message. I have been using the prepaid account (1300) for things like over payments to vendors - overpayments on the utility bill etc. (My boss hasn't been very good at keeping track lately), as well as deposits on…
  • Accounts receivable

    Hello I have just noted a difference of 0.01 between my A/R balance and Unpaid invoices when I ran a Data Integrity Check. When I investigated, I found that the difference arose on the translation of a foreign currency receipt to the home currency.…
  • Data Integrity Check - difference between A/R balance and Unpaid Invoices

    I have just noted a difference of 0.01 between my A/R balance and Unpaid invoices when I ran a Data Integrity Check. When I investigated, I found that the difference arose on the translation of a foreign currency receipt to the home currency. The translation…
  • Last Year Profit and Loss Out by xxxx

    Hello Sage Team, I'm having a strange Data Integrity Issue. I was loooking My Trial Balance and then I got the attached Error (TB Error), I run Data Integriyt then got attached Error (DataError). I Ran the Control Centre & Documentation (CCD…
  • data inconsistencies

    Hi I use Sage 50 DT Expert. In Maintenance, Check Data Integrity, I have Data inconsistencies in A/P balance (-144.98$) VS Unpaid invoides (0.00$). It seems to be a refund on a credit card, which I entered first as an invoice, then corrected it as a…
  • Data Integrity and Error Message.

    Hi! I am hoping you can help me! I ran a data integrity check before I was going to switch over to a new year and it has detected an error. It is showing -$25,000 in A/R as well as $25,000 as cash to be deposited, on the balance sheet. I have looked everywhere…
  • How would you be able to Tell if you Need a Data Fix

    Please Remember the below is a Guideline to assist you with your House-Keeping. Although this is not an exact Science however you can use it as a Guideline so that you could react Swiftly and not break anything in the Process. So, if your answer is…
  • Data Integrity Inconsistencies - Advances & Loans Paid

    I am completing my 2017 Year-End and have checked my data integrity. I get the message that Data inconsistencies have been detected. Advances & Loans Receivable = $0.00 * Advances & Loans Paid = $412.61 I have run my payroll report summery and there…
  • Data inconsistencies in vac pay balance vs vac pay owed

    I was completing a data integrity check prior to flipping our fiscal year, and discovered that there is a data inconsistency (please see below) Vac Pay Balance $233,644.06 Vac. Pay Owed $235,072.96 This means that there is a difference of $1,428.90…
  • AR and Unpaid Customer Invoice amounts don't balance, and I can't start my new year!

    I can't start my new year because they don't balance! I don't know where to look, or how to add in a temp fix so I can move forward. I have an accounting firm go through my books at the end of every year, and I generally just make the changes and additions…
  • Step 1: Check Data integrity

    This step is to ensure that you have no credit/debit imbalances in your accounts and can be completed by using the option under Maintenance > Check Data Integrity Check the integrity of company data How to solve "Data inconsistencies have been detected…
  • AP error message when trying to start new fiscal year

    Hi All; I have a client that recently started using Sage 50 Pro. When he created the company file, he input the Trial Balance values from the year end that he got from the accountant. This included an amount in A/P. Now he is trying to start his new…
  • Step 2: Check Data Integrity

    This step is to ensure that you have no credit/debit imbalances in your accounts and can be completed by using the option under Maintenance > Check Data Integrity Check the integrity of company data How to solve "Data inconsistencies have been detected…
  • Vacation owed, but Vacation Payable account at 0.00

    Hi, I am at year end. I ran the data integrity check & it showed an imbalance in Vac. owed. We actually pay out vac with every pay check, so this is not owing. I need to clear this up. My main problem is the Vacation Payable account has a 0.00 balance…
  • Integrity Summary A/P is not balancing

    Hi all, I was wondering if anyone knows how I can fix my Integrity Summary. All accounts are balanced excepted for my A/P account. It says A/P Balance: $10620.50 Unpaid Invoices: $5710.78 I also would like to close the year 2014 and start 2015.…
  • Data Integrity Error

    Hello, I'm attempting to do my first year - end and I'm coming across an issue with the data integrity check. I am showing that my advances / loans recieved and vacation pay balance do not match with the advances / loans paid and vacation pay owed…
  • clients info does not = current balance of prepaid deposits...

    Hi, I am at year end, and would like to close the history mode. When I try to close, it tells me: "The sum of your Clients' information does not equal the current balance of account 2460 Prepaid Sales/Deposits. -$310.16 Total Deposit and Prepaid Order…
  • RE: Data inconsistencies have been detected

    Hi there, The issue might be in the database. Here are some steps that might help resolve it. First Customer aged (subledger) and Accounts receivable account (general ledger) should match either $301.36 or $301.38. The program displays on Cheick…