Browse By Tags

  • Balance Sheet out of Balance

    Good day. I have contacted Sage several times on this topic and they keep asking to invite support and send the details. I have done this process several times now, and still no positive response from Sage. Is there a quick fix for this? We need…
  • Bank Account Reconciliation does not match TB

    I have reconciled my Sage bank account to the bank statements but the balance showing on my TB is out by £66 even tho I have no unreconciled transactions when I run that report - any ideas? Same problem, different amounts, on other bank accounts to…
  • Check an opening bank balance on a specific day

    Hi, all. I'm wondering if anyone can tell me how I find out what my bank balance was on a specific day. I managed to do it once before but cannot for the life of me remember how I did it.
  • Live Webinar - Management reports - Trial Balance, Profit and Loss and Balance Sheet - Recording available

    Gain confidence with your reports and develop your understanding of what they show and how they calculate. This session has now taken place, but you can catch up with a recording:
  • Trial balance different to Nominals

    My trial balance figures for certain nominal codes are different to the nominal activity. For example; Debtors on the trial balance is showing as £234,415.67 however the nominal activity is showing the balance as £143,171.46. Looking into a detailed…
  • Year End Rollover

    Hi, I'm looking to "rollover" my ledgers into the new year starting 1st April 2023 and want to see the balance sheet items with their retained balances but the profit and loss items reset to zero (and the balances moved to reserves), but at the moment…
  • Trial Balance with ALL codes including zero balances

    Dear Forum, I create my management accounts by mapping a trial balance into Excel. For this to work consistently without having to change excel formulae each month I need the same lines to be reproduced in the Trial Balance each month. I therefore plan…
  • Trial balance

    Hello, need a bit of help, please as I am new in this field. I have received a handover with a trial balance for the previous end of year (2020-2021) in which I found a balance b/fwd (without any other details) put on credit side. Is this the opening…
  • Webinar - Understanding Management Reports - Recording now available

    In this session we explained how the Trial Balance, Profit & Loss and Balance Sheet reports calculate. It followed on from the Chart of Accounts webinar. This event has now taken place, but don't worry, you can catch up with a recording . View the…
  • Net Loss Accumulated - General Ledger Trial Balance

    Hi Team, Need some expertise, there is figure of Net Loss (Accumulated) on extracting trial balance (on the top) I need to know if I want to make changes to that figure what entries will be passed to bring that change. Thanking you, Murtaza
  • How to get transaction values for the nominal ledger in ODBC Sage 200 connection.

    Hi, i'm new to using sage 200 and have been given access to our ODBC connection to review some of the reporting tables available to us. I'd like to create a connection that allows me to pull nominal transactions but while the table "NLPostedNominalTran…
  • Tip - How to import a Sage 50cloud Accounts Trial Balance into Sage Accounts Production Advanced

    If you use Sage 50cloud Accounts alongside Sage Accounts Production Advanced (SAPA), you can export a Trial Balance from 50cloud Accounts and import it into SAPA. Find out how >
  • A/R trial balance

    Is it possible in Sage 50 US (2021 version) to run just an A/R or A/P trial balance?
  • NA-TRLBAL in V12

    V12 the crystal report NA-TRLBAL is deprecated. Is there a way we can still use if the client really wants to use it. I copied from the previous version but it prints blank
  • Trial balance out of balance - how to correct and why does this happen?

    Logged in this morning, pulled a TB report and suddenly it is out of balance. I am busy with month end so this could not have happend at a worse time. How do I fix it?
  • Actual AP vs. AP on the <Standard> BS is Extremely Out of Balance

    Hello! I've been looking through the forums for some time trying to find some assistance to our reports being out of balance, some posts and responses have helped me track down unusual information, but nothing conclusive to help fix the issue(s): -…
  • Sage One Accounting Aged Creditor do not match trial balance

    Hi, I have a balance in account 2100 - Purchase Invoices not paid, however this balance does not appear in my trial balance. A payment was made but after the year end.and the balance should show as outstanding. Please could someone advise how I…
  • TRIAL Balance Pulls Dates out of selected range

    Good evening, When I pull up a TB it shows me details of dates out of selected range. i.e: If I choose to show me the TB from 10/01/2019 to 12/31/2019 it Includes balances of 01/01/2020 up to date. What can I do to overcome this? Using Sage…
  • Historical trial balance reports

    Hi Does anyone know if it is possible to run historical TBs - eg prior year? I am using Sage 50 cloud Accounts Essentials. Thanks Lisa
  • Synchronize Trial balances on stand alone companies

    Dear all, How to synchronize TB's from the last 2 FY to the current FY? We processed accounting data for FY2016, made backup then run Year-end to process FY2017 and again made another backup to run Year-end to process FY2018. After processing…
  • How to set the Period Trial Balance to include Codes with zero balances?

    I've tried to follow a couple of procedures in order to reveal zero balance codes in my TBs but they don't seem to work for me. Has anyone done this successfully? Specifically I'm running the Period Trial Balance report which at the moment only shows…
  • Including Zeroes On Trial Balance Report

    I'm looking to run the TB report (specifically Period Trial Balance) but to include nominal codes where there are no transactions (ie. zero balances). I've tried to edit the report using Sage instructions here but still not getting the full nominal ledger…
  • How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…
  • trial balance entry throws up unbalanced error despite the fact the balance total at the top is zero

    Entering opening TB balances from old system onto Sage 50 v22 - carefully checked every line and both totals at the bottom clearly DO equal each other plus the Balancing Total at the top of the Journal is Zero (showing Debits do equal credits) - so why…
  • The Accounting Equation: A look at the Trial Balance

    Did your accountant only provide you with a trial balance and now you're wondering why the Equity plus (+) Liabilities account doesn't equal to your Assets on the trial balance ? Balance Sheet vs Trial Balance The difference between a balance sheet…