web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Importing Receipts from PowerCampus

(0) ShareShare
ReportReport
Posted on by

Hello,

My company has been using GP for years, but failed to ever reconcile the bank statements through it. I'm attempting to implement this change, but have a question:

I'm understanding that all deposits must go through the cash receipts/deposits to hit the Bank Reconciliation. Right now, they are entered as Journal Entries. All adjustments are entered as JEs. That change is fine. However, our software for our students' accounts is PowerCampus, which exports the receipts to GP. When this happens, it comes over as a JE, meaning it won't apply to the Bank Reconciliation. Is there a way to have it import as a Cash Receipt instead of a Journal Entry?

Thanks,

Dani

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    65,271 on at
    RE: Importing Receipts from PowerCampus

    So that means the import is built in to PowerCampus. That would mean you will have to understand where the data is coming from and fashion an import with an external tool. All possible, just not as easy as we first hoped.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    on at
    RE: Importing Receipts from PowerCampus

    Thank you. I spoke with someone from IT, she said PowerCampus imports directly. We don't use another software.

  • L Vail Profile Picture
    65,271 on at
    RE: Importing Receipts from PowerCampus

    Hi,

    I agree with Matt. You'll need to get to provide additional information to the system, but importing it as a cash receipt should not be a problem. Does the JE that you bring over from PowerCampus match your bank statement? If it does, you might want to import an increase adjustment rather than a cash receipt - you wouldn't have to go through the 'deposit' step. Know that you should never, ever have to make a journal entry to cash (unless you're fixing a problem). Always use a Bank Transaction/Deposit. There isn't any transaction that would require using a JE. In fact, I would open my Account Maintenance screen, pull up the Cash account and uncheck the Allow Account Entry checkbox.

    Kind regards,

    Leslie

  • WindyCityGP Profile Picture
    1,069 on at
    RE: Importing Receipts from PowerCampus

    You may want to take a look at Nolan's Advanced Bank Rec.

    www.nolanbusinesssolutions.com/.../advanced-bank-reconciliation

  • MattPaulen Profile Picture
    6,912 on at
    RE: Importing Receipts from PowerCampus

    What are you using to do the actual import? Integration Manager? SmartConnect? Something else?  I'd imagine it would just be changing it out to import in to the Bank Rec module instead of the GL.  You many need to adjust a few things but it should be doable.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans