Browse By Tags

  • Webinars - Develop and understand your management reports and have a trouble free year end

    You don't need to stop processing just because you've hit year end. Simply continue as normal, creating records, entering transactions, invoices and orders, reconciling bank accounts and your VAT Return, then come back to run year end as and when you…
  • 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:
  • Slow income statement and balance sheet in Sage BusinessWorks 2023

    A hot fix is now available to resolve the issue with slow performance with the income statement and balance sheet for Sage BusinessWorks 2023. To install the hot fix: Have all users log out of the program Download the hot fix Login to www.sagekb…
  • How to pull back missing credit note

    So I had entered a credit note in error then had to create an invoice to pay that credit note and not sure if we had deleted the credit note but it is no longer showing in our system. Problem is that in Sage the cheque is showing as having paid $12,000…
  • Adjusted book balance not matching statement

    I have reconciled my bank accounts and the correct totals are showing with a zero adjustment required in the reconciliation window. Since this is back work (2022) I am working forward and the balance sheet at Jan 1 2022 is not showing the correct statement…
  • Working with the General Ledger or Balance Sheet

    Working with the General Ledger or Balance Sheet can be tricky. But do you know what to do when a General Ledger Trial Balance or Consolidated company is out of balance or assets do not equal liabilities? Find out what to do here .
  • 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…
  • How's your business performing?

    Management reports are a great way to gain insight into specific areas of your business and show the overall value and profitability over a period of time. Find out more >
  • Running management reports for a date range...

    In Sage 50cloud Accounts, management reports such as the Profit and Loss or Balance Sheet are calculated using the period values of the nominal codes in the relevant sections of your chart of accounts. However, sometimes you might want to run the reports…
  • Balance Sheet out a penny - What could have happened?

    Hello All, I have been boggled. The last several months of the balance sheet have been out a penny with a $0.01 showing up in Retained Earnings - Previous Years. I have figured out that the error happened sometime between April 13th, 2021 and May…
  • Balance Sheets ran for same period don't match

    We use Sage 50 Quantum. I ran a balance sheet for period ending 12/31/20 back on February 24th 2021. Today I ran the balance sheet for the same period 12/31/20 and the retained earnings GL is different from the report I ran in February. I am wondering…
  • Sage KB 26049 Duplicate Retained Earnings on Balance Sheet Fix Did Not Work

    Sage 100 6.20.1 Premium GL Reports Financial Reports, the balance sheet report is repeating the Retained Earnings Account. The Sage KB 26049 fix is to create a new Balance Sheet report and with Print GL Accounts off. That did not work. Has anyone…
  • Trying to input an opening Retained Earnings figure in Sage Business Cloud Accounting

    Afternoon all, Last year, we moved our internal profit & loss reporting to the Sage Business Cloud Accounting system, taking 01/01/2020 as our commencement date. We manually input all the various customer/supplier opening balances, invoices, and banking…
  • Retained Earnings out of balance (Sage 50 2020)

    Hello all, I am IT support for a small company that uses Sage. We had a data corruption last year that I worked to clear up and there was a balance issue, but Sage said the only way to fix it was to manually adjust the earnings. I am by no means a tax…
  • 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): -…
  • Balance Sheet "Mapping"

    Hello! I'm stuck! I am new to BW. As I was running periodic reports, I realized that only one of my cash accounts is flowing to Cash and Cash Equivalents on the balance sheet. I checked the set-up of the accounts on the Chart of Accounts; they all appear…
  • Balance Sheet missing accounts

    I recently noticed that the Balance Sheet in one of our companies was not balanced. Upon further review, I discovered that three of the four loan accounts I have created this year are not listed on the Balance Sheet. I have verified the setup is the same…
  • Changing Income Statement to Balance Sheet

    Good day, Could you please assist? I need to change an incorrect setup account from an Income statement Category to a Balance sheet before closing off a year-end. Is there any way of doing this? Thank you in advance. Kind Regards
  • US exchange rate in reports

    Hi, Can someone explain how do I make a monthly entry to adjust the US exchange rate in order to have the right information in the reports. I already use the exchange in each invoices, but I would like to adjust, monthly, with the Canadian Bank monthly…
  • Journal entry for lease payments

    Hi - I have a question on lease payments. We have leased an asset (under a finance lease) and the cost is EUR 4,000 plus VAT of EUR 920 and the payment schedule is 36 monthly payments of EUR 136.67. Ive recognized a non current asset at cost of EUR…
  • Financial Statements: Customer Ledger vs. Balance Sheet discrepancy

    We have numerous companies. This particular transaction affects two of them. It occurs in May 2018. The transaction for Company A is kind of complex: the tenant didn't really pay us the money...we applied their deposit to their past due invoice (past…
  • Financial data extraction print to have at least 12 column (per 12 periods) in order to be exported to Excel!

    One of our biggest challenges in an X3 project, our customer has to run FDE twice (one for first 6 month and then second 6 month of a year) if they want to see the whole year in one report. We do understand that 8 columns fits in a printable page (hence…
  • AP & AR 'linked accounts' can now be posted directly through the General Journal Module? What about data integrity???

    Posting to AP&AR linked accounts in a journal entry? Sage tells me that it was the SAN members that requested to be allowed to post directly to the linked AP & AR accounts in a general journal entry. My question is were these SAN member made aware of…
  • Balance sheet AP doesn't match vendor aged and ledger report of AP category

    Balance sheet shows amount for 'Account Payable' less than it should be. B/S account payable shows 1051.28. In reality there is 1 invoice of 1095.00 remaining unpaid. The 1095.00 is confirmed as final running balance on GL report for the AP category…
  • Manual Income Statement and Balance Sheet

    Long story, need to do an income statement and Balance Sheet manually. I know, obviously, that the Balance Sheet needs to balance. What else? What needs to transfer over? We will use a past year and make some adjustments. If I adjust cash, equipment,…