Skip to main content

#Accounting Subledger0 discussing

Hey, guys! I wanted to ask if someone could recommend an app to integrate Salesforce and Quickbooks Online. We have someone create deposit batches in sf with each opportunity (donation) as a separate record. We'd like these separate records go into Quickbooks Online. Is there an app you'd recommend? Would Subledger do the job?

4 answers
  1. Feb 18, 5:00 PM

    I’ve worked on a similar donations setup where each Opportunity needed to land in QuickBooks Online as its own transaction. Subledger can work depending on how tightly you want accounting logic embedded in Salesforce, but it’s worth mapping out first whether you need just a push of financial records or full accounting behavior. 

     

    In our case, we kept Salesforce focused on fundraising data and used Skyvia to sync Opportunities into QBO as the appropriate financial objects. That gave finance clean transactions in QuickBooks without overcomplicating the Salesforce side.

0/9000

For some reason ASL is not creating any Ledger Entries for Opportunities in a Stage mapped to a Committed State. Transaction and Payment type Ledger Entries are being created as expected for Opportunities in a Finalized Stage, but for an Opportunity with a Stage of Pledged, mapped to a State of Committed, no Ledger Entries are created at all when the batch is run, even though there is a related GAU Allocation and scheduled Payment on that Opportunity. I would expect to see a transaction and allocation type Ledger Entry created for this Opportunity.

Any idea why Committed State Opportunities are not creating any ledger entries? All Opp RT's are enabled for ledger entry creation, and the ASL date range filter includes the Opp create date.

5 answers
0/9000

Hi,

 

I have an NPC sandbox in which I am trying to set up Accounting Subledger. I have done all the Accounting Subledger setup pieces listed here, and I have used this example as a guide to set up Account Sets. We use cash based accounting. I run the subledger job and no transaction journal records are created. When I run the subledger job in debug mode, it says "Inputs None." which leads me to believe it is not finding any records to process even though there are paid test transactions within the Accounting Record Start Date I chose. Any help or suggestions of what to try next would be appreciated. Thanks!

 

#Accounting Subledger #Nonprofit

1 answer
  1. Aug 26, 2024, 3:40 AM

    Hi Melissa,

    I'm guessing you were able to solve this. If not, and if others stumble on this.. it may be due to the Accounting Record Start Date in the Accounting Set. It is possible to get the Subledger job to run while never creating Transaction Journal records if the Record Start Date is set wrong.

     

    The following article explains, "Accounting Record Start Date - If you specify an Accounting Record Start Date, Salesforce only generates transaction journal records for source data whose primary object's created date is on or after that date."

     

    This is not written clearly in the setup guide.

    https://help.salesforce.com/s/articleView?id=sfdo.ASL_Inputs_Impacts.htm&type=5

0/9000
What are the appropriate steps to take to change the GAU on an Opportunity? I've tried reallocating to a new GAU, but because it is associated with a Payment I am getting this error: "Error: npsp.TDTM_Allocation: execution of AfterUpdate caused by: npsp.ALLO_PaymentSync_SVC.PaymentSyncException: The total allocation of paid payments cannot exceed the opportunity allocation for a GAU. (System Code)"
2 answers
0/9000
Hi! On the documentation (https://powerofus.force.com/s/article/ASL-Adjust-Payments

) it is indicated that we should create negative payments to process refunds and reversals. My client specifically needs to create negative ledger entries not for specific opportunities, but as a way to enter credit card fees and other fees in 'bulk' amounts (adding together as many fees as possible from a given batch of deposits and marking it in the system). I figured we could just create a negative value opportunity for this.

However, when testing this functionality, I run into a few different issues.

1. A payment isn't automatically created with a negative-value opportunity. That's a bit aggravating but I can just create a negative payment related to that negative opportunity. Fine, I'll just make one.

2. I can't assign a negative number using the "manage allocations" page in Salesforce. That's troubling, because I need to mark which GAU these fees will be coming out of.

3. Ledger entries aren't created at all. This is obviously a big one. I made a -$500 opportunity and payment, used the default allocation (since I couldn't change it, just wanted to see functionality at the very least), and the ledger entry batch job simply failed to create any entries. I'm not even sure it would have created entries for valid opportunities, but I didn't have any in the system at the time and I haven't tested that specifically. Once I reversed the opportunity from -500 to 500, the ledger entries were populated again when I re-ran the job.

Any ideas on how to tackle this or what the issue may be?

7 answers
  1. May 5, 2023, 11:17 AM

    Looking for solutions to this myself.  My nonprofit is using an older version of Kell Allocations and it has the same limitation.  Ugh, it's like you are so close to having a finished solution but there is one little detail derailing the whole thing.

0/9000

Hello! When merging accounts with completed/pledged opportunities, Accounting Subledger is creating ledger entries for "Account Change" on those opportunities. We do not want to generate ledger entries when accounts are merged. Any ideas on how to tackle this? 

4 answers
  1. Feb 23, 2023, 8:16 PM

    @Melissa Nesbitt, we are dealing with the same question. We have a filter like what @Rick Houston mentioned.  It's a custom field on the Opportunity object, "Exclude from ASL" and we use it as a filter on ASL settings.  My concern about that approach for merged duplicates is that it forever excludes the Opportunity from ASL, but it could have an adjustment in the future that's significant to ASL.  So, we've been letting ASL create the Ledger Entries, then marking them as Denied.  Also not ideal!  It would be nice if ASL had a setting to signal whether a change of Account/Contact on an Opportunity is significant to ASL for our org.

0/9000

Accounting Subledger for Industries Summer '22 Release Notes 📣

 

The Summer '22 Accounting Subledger for Industries release will start pushing to sandbox orgs today. Look for Accounting Subledger for Industries version 1.7.0.1 in your org over the next couple of days. Read what’s in this release in the Accounting Subledger Release Notes.

 

#Accounting Subledger #Accounting Subledger Releases

0/9000

Accounting Subledger Summer '22 Release Notes 📣

 

The Summer '22 Accounting Subledger release will start pushing to sandbox orgs today. Look for Accounting Subledger version 1.40 in your org over the next couple of days. Read what’s in this release in the Accounting Subledger Release Notes.

 

#Accounting Subledger  #Accounting Subledger Releases

0/9000

How do we set up Accounting Subledger so that whenever an opportunity is created and assigned to a primary campaign, Accounting subledger creates the ledger entry with the GAU that matches the primary campaign source?

Essentially, how do we map Campaigns to GAUs?

Thanks,

2 answers
0/9000

Donors give donations on our Website through a third-party (Funraise). Funraise syncs with Salesforce, and creates an opportunity in SF. We use another third-party (Stripe) to process payment and subtract the credit card fees. We would like to track the amount of the donation minus the credit card fees in Salesforce. Any suggestions on how to do it? We are setting up Accounting Subledger, and need the donation amount to include the credit card fees.

Thanks,

Manny

3 answers
  1. Aug 20, 2021, 7:07 PM

    Hey Manny. You could likely use a formula field to do this. How are your card fees structured? Is it a percentage of every transaction?

0/9000