Articles
AR Aging by Effective Date Detail Report in SedonaOffice
The AR Aging by Effective Date report is designed to give a snapshot of AR aging as of a specific date in time. It is also the report which should be used to reconcile accounts receivable to the general ledger.
Report Criteria
When r...
Manual Journal Entries and Retained Earnings
The balance in the Retained Earnings GL account is calculated automatically by the SedonaOffice system based on net profit/loss, and distribution account entries from the years before. Because the value is calculated, the system makes no GL entries ...
SedonaOffice GL OOB Audit Sproc SQL
SedonaOffice General Ledger Out of Balance Audit
Please find included the stored procedure written by Emeka, which can be used to identify sources of out of balance issues in the SedonaOffice general ledger here. .
This stored procedure s...
Journal For This Item Button
On the Top Tool Bar in Sedona, there is a “Journal For This Item” Button that will display the Journal Entry made to the General Ledger for the item currently being viewed.
If the button is Greyed out then this function is not available ...
Permission to Work in Re-opened Periods in SedonaOffice
Description of Issue:
In some situations, users may need access to make changes in Re-Opened Accounting Periods.
Solution:
This is granted in User Groups. Go to SedonaSetup > Find User Groups in the OP area.
Locate any User Groups t...
Re-Opening a Period in a Closed Fiscal Year in SedonaOffice
Re-Opening a Period in a Closed Fiscal Year
Customers cannot open, re-open, or otherwise work in a period from a closed fiscal year. Sometimes they contact us to request we give them this access. We can do this by running a script to set the pe...
SedonaOffice Bank Reconciliation Import
SedonaOffice Bank Reconciliation Import
There is an Import button in the SedonaOffice Bank Reconciliation screen which can be used to simplify the bank reconciliation process. The import requires a bank statement from your bank in QuickBooks ve...
Unable to see offset due to branch division
Sometimes users will complete an operation that occurs on different branches. This could be a void or a transfer. However, they occur on the same account number. In order to see all activity on a given account, the user will need to dele...
Importing Journal Entries
The following steps should be taken when importing Journal Entries into SedonaOffice.
Step 1) General Ledger > Journal Entry - this path will take you to the screen below.
Step 2) Enter a Branch and date only. The date can be the date entr...
What is PPV?
PPV is an acronym that stands for Purchase Price Variance. This refers to the difference between how much the business said their inventory parts are worth, and how much they actually paid for them.
In a perfect world those two amounts would be...
What is WIP?
WIP is an acronym that stands for Work In Process. To judge a job’s profitability, you must match money spent on the job (costs) against money made off the job (revenue). In some cases, the job parts are purchased in one month, but the job is not i...
What is Deferred Revenue
In accrual accounting a company recognizes revenue when they earn it, not when they create the invoice for it.
For example, let's say a customer is billed annually in January for a 100.00 monthly RMR line. In this case the invoice would be 100 ...
Cash Vs. Accural Accounting
Cash Accounting – tracking profit based on cash on hand. Using this method, revenue is equal to how much cash customers gave the business this period, less how much cash the business paid out that period. Using this method of accounting is simple...
Knowing which Accounts to Debit and which to Credit
Whether or not debits and credits increase GL accounts or decrease them is often a source of confusion. It is not as simple as debits always increasing accounts and credits always decreasing them, or vice versa. And it is not always the case that on...
Quick Notes on Accounting
What is Accounting?
Accounting – the practice of recording, reviewing, and reporting on all of a business’s financial transactions to identify the financial health of the business.
Financial Statements – reports used to show the result...
Changing the GL account in a Journal Entry
Note that this is only for use when the system has caused an error that needs to be corrected. Script not for use on user data entry errors.
If a customer needs to update a GL register entry to a different account or the system assigned the ent...
Undoing a Bank Reconciliation
Issue:
A customer is asking to have a Bank Reconciliation deleted so it can be redone.
How is this done in SedonaOffice?
Resolution:
UNDOING OR REVERSING A BANK RECONCILATION in nine easy steps.
Always test this in a sa...
How To Add A Service Ticket Number under the Job Costing Section of a Journal Entry
General Ledger
Under the General Ledger Module select “Journal Entry.”
Entry the Primary Account from the Drop-Down Menu.
Enter the Amount under Debit/Credit
Enter a Memo if needed.
Select a Category if required.
Und...
Script to Insert GL_Register Records from Backup Table
Issue: There may be a need to restore records from a backup of the GL_Register when working on a data issue. Resolution: The records can be copied into the original table from the backup if needed. The script below can be used to restore the ...
Update Accounting Period Months
If accounting periods contain months with the wrong end date, you can use the script below to adjust the date. In the example below February was initially set to end on the 28 th on a leap year and needed to be changed to the 29th. update p ...
Finding N/A Branch in GL_Register
One of the most common causes of reports not matching the Trial Balance is due to a GL entry having a branch_id of 1. Since the Trial Balance report ignores the N/A branch that amount will not factor into balance even if it shows up on other reports...
Find One Sided GL Entry
One sided entries are one of the most common causes of out of balance issues on the Trial Balance report. Instead of running the full GL issues, running just this script may be more efficient on companies with massive databases. Select 'One Side...
Finding Unallocated entries
If a customer has an unallocated amount on their Trial Balance and the total balance is off by that amount, you can use this script to locate the entry on the backend.
Select 'Invalid Account ID' As 'Problem', * From GL_Register glr Wher...
Cannot Close Current Accounting Period
Accounting Periods An Accounting Period that is for the current month cannot be closed until the first day of the following month. If a User tries to Close the Current Accounting Period they will receive a Pop-Up Message. ...
Valid General Ledger Transaction Types in SedonaOffice
Issue:
What re the valid General Ledger transaction types in SedonaOffice?
Resolution:
Below are the valid GL transaction type codes that are available in SedonaOffice.
Register_Type_Id
...
You Cannot Reconcile Future Dated Transactions in Your Current Bank Rec
Users are attempting to reconcile a future dated transaction in the current bank rec. using these steps.
Dated manual journal entry for 2/1 when they had intended to enter 1/31.
They were performing the Jan bank rec. so the bank rec as...
Troubleshooting Tip: Bank Reconciliation - prior cleared section
This article will cover a troubleshooting tip for completing a Bank Reconciliation.
Overview
The prior cleared section should autofill with an amount that matches the last ending balance. If the prior cleared section does not fill in t...
General Ledger Entry for Prior Year (Internal)
Sometimes adjustments need to be made in prior years that no longer have an available accounting period to open in Sedona Office. When this occurs, the first step is to get permission in writing to set a specific period to Re-Open. Once you ha...
All Manual Journal Entries for a Given Period for a Specific Account
If you need to find all manual journal entries for a specific account for a given time period, there’s a few ways to approach the issue. First, you can filter an account by register types, which lets you set the register type to only the General Jo...
Closing Fiscal Year
Sedona Office allows for two consecutive accounting years to be open at the same time. The next accounting period will open up automatically when the oldest accounting period is closed Go to Close Fiscal Year under the General Ledger module Th...
Fiscal years that are not calendar years
When you first go live with SedonaOffice you decide the start date for your fiscal year. If you decide later that you would like to change your fiscal year start date, we can process it. This will be a project and be considered custom work to create...
How to Move Money From One Bank Account to Another
This documentation will go over how to move money from one bank account to another using the Write Check option and GL accounts.
Overview
The steps listed assume the user has the permissions to perform the needed actions.
Steps:
...
How to Setup a Sales Tax Query in QueryBuilder
This document contains steps on how to use SedonaOffice Query Builder to make a list for sales tax. This document covers SedonaOffice versions 6.2.0.x.
Overview
The steps needed to perform this query list assume the user has the permis...
Interbranch GL Accounts Summary
The interbranch accounts are used automatically by the system when the lines of your journal entry hit two different branches.
The debits and credits in every GL entry must be equal. If you have a GL entry with one debit line for $50.00 in Bran...
Repairing Deferred Revenue That Will Not Mark as Posted (Internal)
132139 136328 In the source cases, the user has an unstable environment. Due to this, they experienced some initial Deadlocks when trying to run their Deferred Income Recognition. This left the data in a state where it was marked as having a va...
Script to Update Deferred Revenue When Amount is Understated (Internal)
Issue:
There may be a time when the Deferred Revenue posting shows the amount to process is much less than expected. There can be invoices missing from the table so the deferred is not distributed correctly.
Resolution:
The script...
Insert Missing AR_Advanced_Deposit_Detail Record (Internal)
Issue:
There is an advanced deposit showing on the Open Credit report, but the deposit was reversed or has already been used.
Resolution:
The report looks at the information for the advanced deposit in the AR_Advanced_Deposit and ...
GL OOB Due to Payroll Timesheet Postings
The Trial Balance being out of balance due to payroll timesheet entries is caused by a defect first identified in 6.2.0.20. --First run queries
to find all the affected register numbers --then back up the
affected register numbers SELECT *...
What is Undeposited Funds?
Undeposited funds is a GL account for holding customer payments until it is time to deposit them in the bank. When users enter customer payments, the system makes an associated journal entry. Since we do not know which bank account they want to dep...